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!
|