+ Reply to Thread
Results 1 to 2 of 2

Saving Excel sheet as a semicolon delimited file (.csv)

  1. #1
    e_dog95
    Guest

    Saving Excel sheet as a semicolon delimited file (.csv)

    I'd like some input regarding these delimited file extensions. I have a list
    of email addresses that I'd like to paste quickly into their respective email
    messages.

    However, I'm not experiencing any luck when using any of the text based file
    options. A word from someone who's done this b4?

    Cheers!

  2. #2
    Anne Troy
    Guest

    Re: Saving Excel sheet as a semicolon delimited file (.csv)

    Assuming your email addies are in a column, just copy/paste into Word, then
    (you could record this as a macro):
    Edit-->Paste special as Unformatted Text.
    Ctrl+H
    Type ^p into the Find what box.
    Put a semi-colon in the Replace with box.
    Replace all.
    Also, my Outlook 2003 does not care if it's commas or semi-colons...

    ************
    Hope it helps!
    Anne Troy
    www.OfficeArticles.com
    Check out the NEWsgroup stats!
    Check out: www.ExcelUserConference.com

    "e_dog95" <[email protected]> wrote in message
    news:[email protected]...
    > I'd like some input regarding these delimited file extensions. I have a
    > list
    > of email addresses that I'd like to paste quickly into their respective
    > email
    > messages.
    >
    > However, I'm not experiencing any luck when using any of the text based
    > file
    > options. A word from someone who's done this b4?
    >
    > Cheers!




+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1