Solved: Align Text

[tlchan]

Hi there,

I have a data sheet where column A & B are filled with text data. However some data are with 1 or 2 spaces from left of the cell. What I require is that all data in column A & B be aligned from left of each cell without spacing. How should I accomplish this with VBA or function?

Sample of data attached.


A B C D

[PHP]
Marie 675442 56.11 tytytytyt
Kelvin Low 43445 90.43 fgfget4 egtret
Paul Lim 33444t 54.67 testing Hong

Thanks

[jproffer]

You mean there are spaces when you (I assume that you're) import(ing) the data?

In an adjacent cell: "=TRIM(A1)" would remove all spaces except for one each time there are any spaces.

[tlchan]

Thanks Jproffer for the quick response. It works fine and resolved my problem.

Thank you