F
Freshman
Dear experts,
I've a table of data which column A is for names. However, the name details
of each client (first, last and Mr...) imported from other source files are
in one word, such as:
Freshman/TimCruzMR
Peter/JonesMR
Lily/ElizaAkotMS
In the above examples, firstly, I want to remove the title "MR", "MS".
Secondly, I want to separate the names in one cell:
Freshman Tim Cruz
Peter Jones
Lily Eliza Akot
Please advise how can I achieve my desired results.
Thanks in advance.
I've a table of data which column A is for names. However, the name details
of each client (first, last and Mr...) imported from other source files are
in one word, such as:
Freshman/TimCruzMR
Peter/JonesMR
Lily/ElizaAkotMS
In the above examples, firstly, I want to remove the title "MR", "MS".
Secondly, I want to separate the names in one cell:
Freshman Tim Cruz
Peter Jones
Lily Eliza Akot
Please advise how can I achieve my desired results.
Thanks in advance.