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.
--
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
"murfitUK" wrote in message
...
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.
|