(Msg. 2) Posted: Tue Apr 15, 2008 8:28 pm
Post subject: Re: Remove extra space between first and last names in merge [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If you don't get an answer in the excel newsgroup, you may find the MSWord
> 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.