Spliting Names

  • Thread starter Thread starter Jeffery B Paarsa
  • Start date Start date
J

Jeffery B Paarsa

Hello,

I have a sheet that in Column A names come in "X, Y" X as LastName and Y as
FirstName. Is there a sample that I could split this column into to keeping
LastName in Column A and after removing "," put the firstName in Column B?
 
Select the range/column needs to be changed. From menu Data>Text to Columns
will populate the 'Convert Text to Columns Wizard'. By default the selection
is 'Delimited'. Keep the selection and hit 'Next'.

From the Step2 of the Wizard from the options select Comma and hit Next.

Hit Finish
 
Just to add to Jacob's reply... if that is a comma and a space in between
the names, then in **addition** to selecting the Comma check box, also
select the Space and "Treat consecutive delimiters as one" check boxes as
well.
 
Back
Top