Email downloads into a single Excel cell - data separation reqd.

M

MSA

I hope someone could guide me. I have downloaded email names from outlook and
imported in Excel. Unfortunately all the names are pasted in a single cell
e.g.

smith, john(dept A); kohl, nancy(dept B);................,turner, ted(dept X);

What I would like to do is somehow separate each name into a single cell
separately based on ";" where this character occurs.

Thanks in advance!
 

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

Email (LDAP) data download into a single Excel cell - data separat 1
write all data from web import into single cell 5
I have an excel spreadsheet. I want to export each single rows into a new email on mi 1
Reverse Concatenation (Splitting Single Cell Data into Multiple Ce 5
Split single cell data into multiple colums 3
collecting data from a single cell and putting it into a columof c 1
Pasting multiple cells into a single cell 2
Combining Variables Into A Single Output Cell 3

Top