remove whitespace or tabs

For x = LBound(myArray) To UBound(myArray)
    myArray(x) = Replace(Application.Clean("a" & myArray(x))," ","")
Next

Should do.

still dont work. What I did was in a text file i simply enter numbers. I would type 22 hit enter then hit tab enter 23 tab tab enter 24. I copied this into my userform and submitted it into an array and get 6 values 3 of them blank because of the tab.


22

23


24