Previous Topic Next Topic

Excel Data help

Closed
Lexy - 15 Oct 2010 à 17:43
 RayH - 15 Oct 2010 à 19:07
Hello,
I need to take multiple email addressess from one cell to thier own cell. How do I do that? (IE:
TOADD:<joe@yahoo.com>; jane@comcast.net; bonnie@yahoo.com; should have their own cell like
joe@yahoo.com
jane@comcast.net
bonnie@yahoo.co


1 response

Réponse 1 / 1
RayH
15 Oct 2010 à 19:07
Text to columns.
Use ; as a delimeter

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How to extract data from one excel file to another
zamorin -
zamorin -

2 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response