Separating Names in a cell

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?
 
G

Guest

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 "&"
 

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
separating first and last names 10
Separating names from one cell 3
Separating data in a cell 4
Parsing text in a cell 1
How do I separate first and last names into two columns? 2
Separating Names 10
Separating data in the same cell 1

Top