Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I delete a space in the beginning of a cell...
I'm copying text (data) from Word to Excel 2003 and it's bringing in a space
in the beginning of the cell, such as "_John Smith". What's the quickest and/or easiest way I can delete this? Obviously, I don't want to get rid of the space in between words, just in the beginning of the cell. |
#2
|
|||
|
|||
Answer: How can I delete a space in the beginning of a cell...
How to delete the space in the beginning of a cell in Excel 2003:
And that's it! The space should now be removed from the beginning of the cell(s) you selected.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I delete a space in the beginning of a cell...
You can apply a formula in a helper column and then copy it down. If
your data is in A1, then you will need this formula: =RIGHT(A1,LEN(A1)-1) or this one: =TRIM(A1) The second one will only remove normal spaces that have the ASCII code of 32, whereas the first one will remove the first character even if it is the non-breaking space (code 160). Hope this helps. Pete On Aug 20, 9:49*pm, GSimone wrote: I'm copying text (data) from Word to Excel 2003 and it's bringing in a space in the beginning of the cell, such as "_John Smith". What's the quickest and/or easiest way I can delete this? Obviously, I don't want to get rid of the space in between words, just in the beginning of the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete space at beginning | Excel Discussion (Misc queries) | |||
Remove space at beginning of each name | Excel Discussion (Misc queries) | |||
eliminate space at beginning of line | Excel Worksheet Functions | |||
How do I delete an extra space in every cell in a column? | Excel Discussion (Misc queries) | |||
How do I remove a blanck space from the beginning of a formula? | Excel Worksheet Functions |