| 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??!! -- |
|
#2
|
|||
|
|||
|
It kinda depends on how your data is structured, with spaces between
initials or not...........but you could experiment with the Edit Replace Find what: space***space Replace with: space,......... and see how it goes........or maybe use space*space, or space**space, etc etc until you get it.......may take a couple of tries.......then maybe replace "Mr Mrs" with "Mr & Mrs".........etc etc Vaya con Dios, Chuck, CABGx3 " ion.com wrote in message tration.com... 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??!! -- |
| Reply |
| 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) | |||
Linear Mode
