Trim function to remove blank spaces in Excel

N

Natty

Hi,

I have a worksheet and I would like to delete some blank spaces at the
beginning of text in a bunch of cells. I have tried the TRIM function but
cannot get it to work. Can anyone help? I can email an example of the
spreadhseet I am having problems with. Thanks!
 
G

Gary''s Student

Make sure they are genuine blanks and not some other invisible character like
CHAR(160)
 
Top