Blank spaces

  • Thread starter Thread starter Scurloc
  • Start date Start date
S

Scurloc

Hi all,

I have loads of cells in a column with a blank space at the beginnin
of the text in each cell.

I would like to get rid of the blank spaces at the beginning of eac
cell's text, but without getting rid of the blanks included in the bod
of the cells' text.


Anybody knows how I could do this?

Thanks for helping m
 
Use the TRIM function to remove spaces at either end of a text string.
It will not eliminate spaces between words.


Cheers,

Steve
 
You could use =RIGHT(LEN(A1)-1) in a helper column, then drag down to the end
of your data. Then, select this range, copy, and "Paste Special->Values"
into your original column (change the reference of A1 to fit your data)
 
SteveG said:
Use the TRIM function to remove spaces at either end of a text string.
It will not eliminate spaces between words.
Click to expand...

.... but it will reduce multiple spaces to a single space.
 
Back
Top