I have names in an Excel spreadsheet that are typed with the first and last name together. I need them separated into two columns, first name and last name. I have tried using the left function with the find function (to find the space after the first name) but I am not doing it correctly. Some names (of couples) have both first names together. I would separate those onto two lines.
Also, once I get the names separated, I need the last name to appear in all caps. Excel does not have a font/all caps feature like Word does. Any suggestions?
Please use left and right -- and mid, only if you have to.
Thanks for your help.