View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gloria81101 gloria81101 is offline
external usenet poster
 
Posts: 3
Default 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.