Importing comma separated email addresses into excel

Originally Posted by AshleyQuick

Is there a way to import comma separated email addresses into excel so that each email address is on a different row? If not, I'm in for a long couple days.

if you've got them all in one cell you could use data ->text to columns and just delimited by commas.
it'll put the email addresses into a different column.
you can then select those values, choose copy, then paste special transpose and it'll be in row form.
that'll only work if you have under 256 addresses though...

hth

Originally Posted by AshleyQuick

Worked great. I just need to repeat it several hundred times but this will ultimately save me a ton of time...Thanks!

oh we can do better than that

why do you need to do it a 100 times?