Extracting surname and initials from string using formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Morning All,

I have a Word document which, via DDE, links to our database. Through this
I'm extracting a name field which as an example, gives you 'Mr John James
Smith'; however, I'd like to extract from this string 'Mr J J Smith' and
'Smith'. Can anyone help please?

Kind regards,
Fry
 
It can't be done with fields as part of a merge. You will have to do this in
your data source.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Dammit! Thanks for the swift response, Graham.

Graham Mayor said:
It can't be done with fields as part of a merge. You will have to do this in
your data source.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Click to expand...
 
Back
Top