Removing "Unkn" from name

[st_judeu@yahoo.com]

Hello All,

In the attached, column 3 has titles and the first names joined together.

What I want to do is to

1. For the names with "Mr" or "Mrs", create a space between title and first name
2. For the names with "Unkn", remove the tile "Unkn" and leave the first name.

Hope my explanation is clear enough.


Thanks

[AlKey]

You can use formula in any empty column

enter in G2 and copy down

Please Login or Register  to view this content.