Mail Merge- Remove Prefix

[bernie10]

Hi everyone,
I have a simple letter that is being generated from a mail merge in Word. One of the names I am using has a prefix ("Mr. John Smith") from the datasource and I need to strip the prefix off ("John Smith").

If this were excel I would do:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

where A1 is the name that needs to be edited. Can I do something similar within the mail merge?

Thanks,
Collen

 

[SkipVought]

Hi,

No. Must be done in the source data.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[macropod]

Hi Collen,

You can use field coding to parse dates, times and numeric strings delineated by '+' or '-', or to perform maths to extract portions of numbers, but that's about it. There is no field code support for parsing text.


Cheers
[MS MVP - Word]