Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove extra space within text
I just had some really great help with some Excel files from this group where
the formatting was done by various people over the last 15-20 years. These are names for genealogy, and I am loading many Excel files into Access so people can search by name and soundex. I don't know if the other problem I am dealing with can be handled programatically, but some of the people in the past entered extra spaces between the first and middle names. I am going thru the files manually now and removing the extra space. I have more files to do and thought it was worth asking if a macro could do this. Here are some examples: John William (I change to John William by using delete key) Doris Doe Smith (I change to Doris Doe Smith) John W. ( change to John W.) I found many posts on this site that talks about Trim, but could not find anything that specifically addressed just removing extra space within text. Thanks in advance if there is any help for me, Sherry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove extra space when text wrapping? | Excel Worksheet Functions | |||
How can I remove extra space when using autofit in Excel 2003? | Excel Discussion (Misc queries) | |||
How do I remove extra space when text wrapping? | Excel Discussion (Misc queries) | |||
Remove an extra space after a number. | Excel Worksheet Functions | |||
Remove Space in Text | Excel Discussion (Misc queries) |