B Beverly-Texas Oct 15, 2009 #1 That pretty much says it... I need to remove a blank space at the beginning of content in a cell. Thanks in advance!
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 Oct 15, 2009 #2 =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
=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
