| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete space at beginning
Hi All
Is it possible to delete the space at the beginning of a cell of data? I have a list of addresses for a mail merge and some (not all) have a space at the beginning of the data. Ideally the find and replace (rather than a formula) would be best. Example (in the first one the address has a space): 1 Corsica Street 22 High Street Any help greatly appreciated Kind regards Rexmann |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove space at beginning of each name | Excel Discussion (Misc queries) | |||
| eliminate space at beginning of line | Excel Worksheet Functions | |||
| How do I remove a blanck space from the beginning of a formula? | Excel Worksheet Functions | |||
| Delete space | Excel Discussion (Misc queries) | |||
| Is there a way to use the space bar to delete? | Excel Worksheet Functions | |||
Threaded Mode
