| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting large gaps in address
I am using a large Excel spreadsheet to address my letters using mail merge.
When I merge some of the addressee names have multiple spaces between the first and the last name. How can I clear this up in my spreadsheet before I merge without doing it manually. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting large gaps in address
If data is in A1 type =Trim(A1) this should give you the right result
-- -John Please rate when your question is answered to help us and others know what is helpful. "gloria81101" wrote: I am using a large Excel spreadsheet to address my letters using mail merge. When I merge some of the addressee names have multiple spaces between the first and the last name. How can I clear this up in my spreadsheet before I merge without doing it manually. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find gaps or breaks in a large column | Excel Discussion (Misc queries) | |||
| Gaps In Bin Locations | Excel Worksheet Functions | |||
| Minimize range on vertical axis with large data gaps | Charts and Charting in Excel | |||
| Transpose Column With Gaps to Row With No Gaps? | Excel Discussion (Misc queries) | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
Linear Mode
