Dear all

I have encountered a problem with splitting the text without a delimiter

I have a list of names with their salutation, however, the colleague did not make a "space"after the salutation

Example

DrTsangEric
ProfEricTsang
MaryGoMs
TomhankMr

How can i split them as
Salutation Firstname Lastname as Dr Tsang Eric

Appreciate if you can enlighten me

Eric