Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking apart email addresses that list more than one on a row
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking apart email addresses that list more than one on a row
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I eliminate bad email addresses from column list? | Excel Discussion (Misc queries) | |||
excel list of names, addresses and email to address book/contact list??? | Excel Discussion (Misc queries) | |||
List of email addresses | Excel Programming | |||
import email addresses into an excell list | New Users to Excel |