View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
alh alh is offline
external usenet poster
 
Posts: 1
Default How to avoid extra spaces in 1st line of mailing address

I am using Excel spreadsheet data to merge into a Microsoft Word mailing
label template. The first line of the label draws from this info on Excel:
MrMrs, 1st name, and, 2nd name, last name. When the merge occurs, sometimes
there is an extra space before the 1st name and then sometimes extra space
between names. How do I avoid these extra spaces?