+ Reply to Thread
Results 1 to 3 of 3

How do i make a paragraph of emails into an excel spreadsheet?

  1. 11-05-2008, 07:29 PM #1
    zoezoner
    zoezoner is offline
    Registered User
    Join Date
    11-05-2008
    Location
    seattle
    Posts
    1

    How do i make a paragraph of emails into an excel spreadsheet?

    Please excuse me, but i never use excel...ever... but need to to format my website mailing list into a bulk mailing application to send out email announcements...

    I have a large email list for my website and i am trying to import that list into excel so that each email is in it's own cell in column A...

    However every time i import the list, which i have tried with each email separated by a comma, semi-colon, space, it imports the whole list into one cell.

    How do i take the giant paragraph of over 3000 emails and get them all individually on their own line in excel?

    thank you and excuse my ignorance
    Reply With QuoteRegister To Reply
  2. 11-05-2008, 08:25 PM #2
    sglife
    sglife is offline
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    What's this email paragraph looks like?
    Is there any separate symbols between 2 emails?
    I need your support to add reputations if my solution works.

    Reply With QuoteRegister To Reply
  3. 11-05-2008, 08:38 PM #3
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    The word "paragraph" I think hints at the problem. When you import, each LINE is imported into a row in Excel. A paragraph gets imported as a single line, i.e. a single cell.

    You'll have to fix your data first. Open the paragraph in Word or EditPad and make sure all your email addresses have an ENTER at the end so they are all on lines of their own.

    Perhaps a search/replace for .com(space) and replace with (.com^p), etc. Should be able to do it in a minute or two this way.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1