Splitting 1 cell w/2 words into 2 separate cells

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
 
E

Earl Kiosterud

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.
 
Top