Trim function to remove blank spaces in Excel

  • Thread starter Thread starter Natty
  • Start date Start date
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!
 
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
How do I remove extra space when text wrapping? 2
Excel Concatenate with line breaks but ignore blank cells 3
Remove Spaces After Number 2
Removing leading/trailing spaces 2
Removing blank spaces from the ends of email fields? 2
Code for Trim function 2
TRIM 3

Back
Top