Remove extra space between first and last names in merge

  • Thread starter Thread starter Jillie
  • Start date Start date
J

Jillie

I have tried everything. I did a mail merge in Excel and cannot seem to
remove the extra space between the first and last name in the address block
on the letter when no middle initial is available.

My data fields are FirstName, MiddleInitial, LastName and some people do not
have a middle initial so that field is blank for them in the data source.

When it prints, the people without a middle initial have two spaces between
their first and last names! Please help. thank you.
 
If you don't get an answer in the excel newsgroup, you may find the MSWord
newsgroup helpful.
 
Back
Top