I have been provided with a spreadsheet with one column, a list of names. I want to separate out the surname into a separate column, but the format in which the names are written is not consistent. For example:
John Smith
James Edward Brown
Mr Michael Q Evans
In each case, the surname is the last word in the name, but Text To Columns doesn't seem to cope with this. I would appreciate any suggestions.
John Smith
James Edward Brown
Mr Michael Q Evans
In each case, the surname is the last word in the name, but Text To Columns doesn't seem to cope with this. I would appreciate any suggestions.