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
Bookmarks