| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Extracting surname and initials from string using formula
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 |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Extracting surname and initials from string using formula
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 Word MVP web site http://word.mvps.org Fry wrote: 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 |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Extracting surname and initials from string using formula
Dammit! Thanks for the swift response, Graham.
"Graham Mayor" wrote: 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 Word MVP web site http://word.mvps.org Fry wrote: 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 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Title Forename Surname | Mailmerge | |||
| How do I get my initials andname in comments? | Microsoft Word Help | |||
| how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
| How can I keep initials and surname together? | Microsoft Word Help | |||
| How to get contact list when creating envelope address in surname | Microsoft Word Help | |||
Linear Mode
