=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.

EditReplace

What: Alt + 0160 (on NumPad)

With: nothing.


Gord Dibben MS Excel MVP

On Thu, 15 Oct 2009 09:36:16 -0700, Beverly-Texas
wrote:

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