| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Leading Space in Cell | Excel Discussion (Misc queries) | |||
| Removing leading and trailing space... | Excel Discussion (Misc queries) | |||
| removing a single space in a cell | Excel Discussion (Misc queries) | |||
| removing a space between words in a cell | Excel Worksheet Functions | |||
| Removing a space within a cell | Excel Worksheet Functions | |||
Hybrid Mode
