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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you remove trailing spaces withour Trim function? 8
Trailing Spaces in Merged Cells 1
Removing leading/trailing spaces 2
Excel Concatenate with line breaks but ignore blank cells 3
Excel trim not working 5
Code for Trim function 2
blank spaces in front of a number prevents formatting cell 2
Deleting spaces in blank cells 2

Top