Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email downloads into a single Excel cell - data separation reqd.
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email downloads into a single Excel cell - data separation reqd.
Look into Text to Columns under the Data menu.
Regards, Paul -- "MSA" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I email a single spreadsheet tab in excel? | Excel Discussion (Misc queries) | |||
Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
How to email a single worksheet in Excel 2007? | Excel Discussion (Misc queries) | |||
mailmerge to a word document from email addresses in a single cell of an excel sheet | Excel Programming | |||
single Email address from one sheet - multiple data from another | Excel Programming |