I have an Excel file with a list of fullnames, and telephone numbers. It is a big list. For example;
"Michael Man" in one cell.
Can I split this up into 2 cells, a first name and a surname? Because people can have middle names, I only want it to transfer the last word into a separate cell.
Can anybody tell me how? Thanks!
"Michael Man" in one cell.
Can I split this up into 2 cells, a first name and a surname? Because people can have middle names, I only want it to transfer the last word into a separate cell.
Can anybody tell me how? Thanks!