Separating Names in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a lengthy trade list of some mom & pop businesses. They have used two
columns for the first and last names. However, for the first name they
included both mom & pop in that cell (i.e. Harold & Lucy). Is there any
formula to pull those first names into two separate cells?
 
You could try this to see if it is what you are after.

Data....text to columns...delimited...then check 'other' as the delimiter
and put the & symbol in the box. This should split any names seperated by
the "&"
 
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 Names in a Cell 3
How do I separate first and last names into two columns? 2
Coping part of a cell content into a seperate cell 3
Separating names from one cell 3
Separate first and second name in one cell into separate cells. 3
Parsing text in a cell 1
Data separation 1
Separating data in a cell 4

Back
Top