Thanks, Ron-- that worked. And I learned a bit about Word/Excel. And I did
save these instructions in a document that I will use next year when I have
to remember once again how to do this.

Onward...

"Ron Rosenfeld" wrote:

On Sun, 5 Mar 2006 11:47:02 -0800, Burger23
wrote:

I originally saved in Word as doc file. Then, after realizing my error, I
saved it as a txt file. But Excel does not understand how to open (import)
the txt in this format:

<CRemail3@ema il.com<CR

It wants to know what the delimiter is- and will not accept <CR If no
delimiter is used, all email addresses are imported in a single cell.

Thanks for your help...

"Ron Rosenfeld" wrote:

On Sun, 5 Mar 2006 09:45:28 -0800, Burger23
wrote:

I had troubles with this method. I copied the names into Word and used the
find and replace function to replace the "," with a <CR. Then I saved it and
attempted to open it as an Excel file. DID not work- file looked like machine
language. Then I copied the <CR delimited to Notepad and attempted to open
this as an Excel file. This worked- but placed all entries in a single cell.
During the Import process Excel Text Import wizard asks about formatting-
tried to use <CR as separator, but that did not work.

Weird. Did you save it, from Word, as a TEXT document, or as a Word document.




--ron


Did you actually type in the four characters <CR in the replace field? If so,
that is the problem

I meant it as a euphemism for the Carriage Return ASCII code which, in Word, is
called a "Paragraph Mark". Since I didn't know which editor you might use, I
did not specify the particular routine for Word.

With your file loaded in Word

1. Edit/Replace
2. Find What: ,
Replace with:
More
Special
Select "Paragraph Mark"
(you should see ^p in the text box)
3. Then hit "Replace All"


(y
--ron