Removing Leading Space in Cell
That pretty much says it... I need to remove a blank space at the beginning
of content in a cell. Thanks in advance! |
Removing Leading Space in Cell
=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! |
All times are GMT +1. The time now is 07:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com