I have over 2000 postal title in the following formats:
MR L A & MRS T L SMITH
MR L A SMITH
MR L A SMITH, MISS T L JONES & MASTER J S SMITH
etc etc
I want to convert it to a salutation as follows:
MR & MRS WALTON
MR SMITH
MR SMITH, MISS JONES & MASTER SMITH

I basically want to remove the initials to leave the title and surname.
As far as I can see I need to remove all text characters except "&" that
are 1 character in length.
Can anyone help??!!


--