LewisReeder
IS-IT--Management
I used to know how to do this but I havent done it in years.
I have a column with peoples names and each cell looks something like this "Smith, John" (no quotations). I want it to look like "John Smith" but I'll take it if I can have the first and last name in separate cells. I just forget what the script is to cut it off after the comma. Can anyone help me out with this little predicament?
Any advice is much appreciated,
Lewis
I have a column with peoples names and each cell looks something like this "Smith, John" (no quotations). I want it to look like "John Smith" but I'll take it if I can have the first and last name in separate cells. I just forget what the script is to cut it off after the comma. Can anyone help me out with this little predicament?
Any advice is much appreciated,
Lewis