Hi, I have a spread sheet where my data is a bit mixed up. For example:
Column A Column B Column C Column D
John Joseph Smith 01/01/1986
Peter Black 15/01/1956
I basically need them all in a Forename/Middle/Surname/DOB order and if they don't have a middle name then that cell can be blank. HELP!?
Column A Column B Column C Column D
John Joseph Smith 01/01/1986
Peter Black 15/01/1956
I basically need them all in a Forename/Middle/Surname/DOB order and if they don't have a middle name then that cell can be blank. HELP!?