How do I remove leading spaces the column is left justified

[mar]

How do I remove leading spaces in an address column. The column is already
left justified.

 

[Gary''s Student]

See Excel Help for the TRIM() function.

 

[Bob I]

Use the TRIM function.

 

[Gord Dibben]

=TRIM(cellref) in a helper column.

Copy down.

Select the column and Copy>Edit>Paste Special>Values>OK>Esc.

Delete original column.


Gord Dibben MS Excel MVP