Hi, I'm in Excel 2013 for this question.
I routinely get system generated email lists and unfortunately they don't
come to me in the format that I need. I have hundreds of rows of email
addresses like the ones that I show below.


, ,
,

The first row that lists one email is perfect.
The second and third lines that list more than one email are not good. I must
break them apart manually and place on separate rows. Obviously this is time
consuming (and frustrating). Can anyone tell me how I might quickly do
something (macro perhaps) that would break apart these lines with multiple
email addresses and place them on rows of their own? Thank you so much.

Normally, I read source data files into an array and process from there to a
worksheet. This requires the generated data files be plain text files
(regardless of file extension) that can be read in a text editor (like Notepad
for example). Making a custom procedure to process your lists 1 file at a time
is fairly easy, but I need answers to the following...

In what format are these 'system generated' email lists before you import them
into Excel?
What is the file extension of the lists files?

If text files, are they all located in the same folder, or do you need to
browse various locations?

Are the lists appended to existing worksheet data?
What column are the lists stored in?

...in order to be able to help you with this.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion