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.