M mar Aug 31, 2009 #1 How do I remove leading spaces in an address column. The column is already left justified.
G Gord Dibben Aug 31, 2009 #4 =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
=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