Clean & Trim Commands

[fvisions]

Excel 2007, how do you write the clean or trim command into a spreadsheet? I am trying to remove the leading space in a column and excel help menu is no help.

Where do i type =trim or =clean in the cell above the data or in the cell with the data?

Header: col A Row 1= Supervisor
Data: Col A Row 2-2,000 = Supervisor's name list (with a leading space)

 

[Ragnar1211]

If neither clean or trim are removing the leading space it sounds like you have a char(160) problem.

=trim(clean(substitute(a2,char(160),"")))

 

[schielrn]

Put this in column B next to the cell and use:

=trim(A2)

Then copy all the way down and then copy and past values over column A.

Hope that helps.

 

[Neavalmi]

If neither clean or trim are removing the leading space it sounds like you have a char(160) problem.

=trim(clean(substitute(a2,char(160),"")))

I have the same problem and this is the one that works for me.