I have a “challenge” that I have been thinking about for one week now.
I have an excel, which contains some columns, one of them is “Name”, where I get a String in a cell from the name and the Surname, I.E: Andrea Johnson
Whaty I want, is to find some of way to separate names from surnames. You can think is easy because most of the people have only one surname, so you could just say last substring is surname and first is name, but for example, in Spain we have 2 surnames, and some surnames even contain more than one word for surname I.E: Andrea Johnson De Santamaría
Any ideas on how to get that? Looks kinda difficult tbh, I tried some regex expressions like this but nothing seemed to help me
Any help? Thanks in advance!!!