Data separation

  • Thread starter Thread starter CandiC
  • Start date Start date
C

CandiC

I currently have a spread sheet that has the first and last name in one
column as, Smith, John. I really need to break these names apart and have
them populate two separate colums. Any suggestions?
 
Hi,
Highlight the column then do text to columns, delimited, check the box that
says comma, next, finish
it will split in two columns

if this helps please click yes, thanks
 
Back
Top