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! |
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! |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com