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 / Word / Mailmerge and Fax / August 2005

Tip: Looking for answers? Try searching our database.

Mail merge - using initial letter of field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
murfitUK - 02 Aug 2005 23:27 GMT
I am using an Excel spreadsheet for my mail merge into Word.

How can I get Word to print only the first character of a field?  I have had
a look at the switches in the help files but can't find what I'm looking
for.

The data in the spreadsheet is in the format:

Mr   John   Smith   address etc
Mrs  Ann    Brown   address etc

and I would like Word to print the letters:

Mr J Smith
address
etc

Mrs A Brown
address
etc

Is it possible?  Thanks for your help.
Doug Robbins - 03 Aug 2005 04:58 GMT
Your best bet is to manipulate the data in Excel.  If the firstname is in a
separate column, just use a formula that uses the Left() function.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using an Excel spreadsheet for my mail merge into Word.
>
[quoted text clipped - 18 lines]
>
> Is it possible?  Thanks for your help.
 
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.