Remove extra space between first and last names in merge

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.
 
D

Dave Peterson

If you don't get an answer in the excel newsgroup, you may find the MSWord
newsgroup helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make elements in a row space between instead of wrapping when choosing multiple columns 0
Grouping Names in Mail Merge 0
Remove extra space between first and last name when there is no mi 7
Remove extra space in name when no middle initial is available 0
Mail Merge Directory Conditional Page Break 0
OneDrive substituting "+" sign in place of space 0
Duplicate Mail Merge Record Every Time 5
Problem with SET & REF function 0

Top