splitting up information in a cell

D

dmedina

how can I split up one cell containing first and last name into individual
cells for each of them? I have a file that has names in one cell and I want
to seperate them so that I can sort them.
 
M

M Kan

If they are separated by a delimiter, such as a comma, you can use the text
to column function. You should find this in Main Menu: Data: Text to
Column: Delimited
 

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

Top