Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I eliminate bad email addresses from column list? belharris Excel Discussion (Misc queries) 2 December 9th 08 02:23 AM
excel list of names, addresses and email to address book/contact list??? anna Excel Discussion (Misc queries) 0 October 24th 08 05:49 PM
List of email addresses Aidan Excel Programming 2 May 8th 08 04:02 PM
import email addresses into an excell list Big John New Users to Excel 3 December 19th 05 07:21 PM


All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"