Separate First and Last name from one cell into two

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

How can I take a cell that contains both the first and
last name and either separate out the last name so I can
sort by the last name or can I change around the first
name last name to be last name, first name?

Thanks for your help.

Karen
 
Select the column and do Data > Text to Columns.

HTH
Jason
Atlanta, GA
 
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

Separate parts of a name into three cells 3
Separating Text 2
Separate first name, middle name and last name 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Need to alphabetize data from separate cells within same row 2
Separate First Name MI and Last Name into three Cells 3
Text Separation Function 6
Function similar to "LEFT" 3

Back
Top