Removing Leading Space in Cell

B

Beverly-Texas

That pretty much says it... I need to remove a blank space at the beginning
of content in a cell. Thanks in advance!
 
G

Gord Dibben

=TRIM(cellref)

On the other hand, if you copied the data from a website you may have a
non-breaking space which TRIM won't find.

Edit>Replace

What: Alt + 0160 (on NumPad)

With: nothing.


Gord Dibben MS Excel MVP
 

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

Format number 2
wrapping text in cell 3
Removing leading and trailing space... 2
Splitting cell contents into other columns 1
Copy and replace 1
Remove blank space in front of text in multiple cells at once 2
Finding (and eliminating) hidden "space" character 8
How do I remove spaces at the beginning of cells? 3

Top