How do I remove leading spaces the column is left justified
 

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

How do I remove leading spaces the column is left justified
 

See Excel Help for the TRIM() function.
--
Gary''s Student - gsnu200902


"mar" wrote:

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

How do I remove leading spaces the column is left justified
 

Use the TRIM function.

mar wrote:

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

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.