| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
want to remove all text characters equal to one character in length from text string
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??!! -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REMOVE SPECIAL CHARACTERS FROM TEXT CELLS | Excel Worksheet Functions | |||
| How do I remove all text to the left of the @ in an email address | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| remove spaces in text in excel | Excel Discussion (Misc queries) | |||
| Remove single text characters | Excel Discussion (Misc queries) | |||
Threaded Mode
