Creating a salutation from a postal title
Posted by Mike on June 13, 2000 7:48 AM
I have imported a series of postal titles that I need
to strip out the intials in order to use the title and
surnames for the Dear etc for use in a mail merge letter.
Detailed below is an example of what I have in cell
Mr I C & Mrs E Butler
Mrs L Mcpherson
Mrs J B Watt
Mr J & Mrs A Gray
Mr J W & Mrs A Barrett
The results I need to obtain are:-
Mr & Mrs Butler
Mr & Mrs Gray
Mr & Mrs Barrett
Does anyone out there have any ideas?