How to delete characters before "." in a string

[Anonymous]

Hello! I have a text column. it is like:
Dr. Helen Malinpn
Dipl. Wen Yu

Dr.Med. Linda Holm

Dr. Mary Julp
Dr. Med. Msc. Lucas Sobe

What I expect is:

Helen Malinpn
Wen Yu

Linda Holm

Mary Julp
Lucas Sobe

Please help. I tried use replace "Dr. "with null, but then I must list all the possible titles used in the column, which is not easy to find out all the possible titles and their combinations-

[Thennarasu_R]

Hi @Anonymous 
Use delimeter in Power Querry

Thanks ,
Thennarasu

[Anonymous]

Aha, it should be from the end of the input. 

[Thennarasu_R]

Hi @Anonymous 
try this Measure,
it will help you

Thanks,
Thennarasu

[Anonymous]

Thank you!  I also have cells without "."  For example:

Ludin Masson    if I use the method you mentioned, then it becomes Masson. His first name disappeared. Pls give further guidane. 

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

You go to Power Query => the click at the column => in the transform tab click extract => then click at text after delimiter => and you put the dot

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin