Remove extra space between first and last names in merge



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.

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