Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Remove extra space between first and last names in merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jillie - 15 Apr 2008 18:58 GMT
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 - 15 Apr 2008 22:28 GMT
If you don't get an answer in the excel newsgroup, you may find the MSWord
newsgroup helpful.

> 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
[quoted text clipped - 5 lines]
> When it prints, the people without a middle initial have two spaces between
> their first and last names! Please help. thank you.

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.