Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
e_dog95
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default 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" wrote in message
...
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
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
Saving sheet to text file Rob Excel Discussion (Misc queries) 4 December 9th 05 09:55 PM
Saving excel document as a .csv and not lose formats? karenv Excel Discussion (Misc queries) 1 October 26th 05 06:17 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 08:46 AM.

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"