replace dot after single character with nothing
m Experts:
I got the following sort of strings in Column A:
Prof. Dr. med. John F. Kennedy
Dr. Andrea Skan
Prof. John B. Sutherland
James D. Sucker
etc.
I would like to insert a formula that replaces the dot after the above single characters with nothing, i.e. after inserting the formula the strings should look like this:
Prof. Dr. med. John F Kennedy
Dr. Andrea Skan
Prof. John B Sutherland
James D Sucker
etc.
The bolding of these single characters is just for emphasis, in reality there are no bold characters.
Help is much appreciated.
Thank you very much in advance.
Regards, Andreas
I got the following sort of strings in Column A:
Prof. Dr. med. John F. Kennedy
Dr. Andrea Skan
Prof. John B. Sutherland
James D. Sucker
etc.
I would like to insert a formula that replaces the dot after the above single characters with nothing, i.e. after inserting the formula the strings should look like this:
Prof. Dr. med. John F Kennedy
Dr. Andrea Skan
Prof. John B Sutherland
James D Sucker
etc.
The bolding of these single characters is just for emphasis, in reality there are no bold characters.
Help is much appreciated.
Thank you very much in advance.
Regards, Andreas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Syed, thank you very much for your swift help. As a matter of fact I am afraid to tell you that you must have misunderstood my requirements.
I wanted to have the the dot after the single characters replaced with nothing, e.g.
John F. Kennedy
Result John F Kennedy
James L. Gartner
Result: James L Gartner
I wanted to have the the dot after the single characters replaced with nothing, e.g.
John F. Kennedy
Result John F Kennedy
James L. Gartner
Result: James L Gartner
ASKER
Dear both, thank you very much for your swift and great help.
Ryan: great, exactly as I wanted it, thank you very much for it.
Saqib: although you misunderstood my question, your approach will be handy for me for other cases.
Ryan: great, exactly as I wanted it, thank you very much for it.
Saqib: although you misunderstood my question, your approach will be handy for me for other cases.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow Saqib, I am really impressed, works like a charm.
It is always difficult for me to decide whether to award points right away or wait for amended/revised formulas. But you are right, next time I will wait.
Again, thank you very much for your great help. I really appreciate your expertise.
It is always difficult for me to decide whether to award points right away or wait for amended/revised formulas. But you are right, next time I will wait.
Again, thank you very much for your great help. I really appreciate your expertise.
DeleteSecondInitials.xlsx