How do I remove leading spaces the column is left justified
=TRIM(cellref) in a helper column.
Copy down.
Select the column and CopyEditPaste SpecialValuesOKEsc.
Delete original column.
Gord Dibben MS Excel MVP
On Mon, 31 Aug 2009 12:36:01 -0700, mar
wrote:
How do I remove leading spaces in an address column. The column is already
left justified.
|