tlchan
01-02-2010, 08:21 AM
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
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