Splitting 1 cell w/2 words into 2 separate cells

  • Thread starter Thread starter Gary Hopkins
  • Start date Start date
G

Gary Hopkins

Hey everyone!

I have a listing of fantasy football players listed as (Firstname Lastname)
in one cell. How can I split them up, so the first name is in one cell, and
the last name in another? I need this so I can then sort by last name.

Thank you!

Gary
 
Gary,

Select the column, then use Data - Text to columns. Specify a space as the
delimiter. Ensure that the next column is currently empty first.
 
Select the range with the names
Use Data|Text to Columns

best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating cells with text 1
Splitting cell contents into 2 cells 1
Separate first and second name in one cell into separate cells. 3
splitting up information in a cell 1
how do i split a cell into 2 under a heading 2
Splitting data in cells 2
Text to Columns Problem 4
Formatting cells containing certain words 1

Back
Top