I have a listed of email addresses in a word document seperated by
commas.  I want insert the list into an excel document and have each
email address be in a seperate cell.  How can I do this

---

Request for Question Clarification by cynthia-ga on 29 Aug 2006 15:15 PDT

Follow these instructions and tell me when you are successful:

Explanation: Comma Separated Value files 

These are sometimes referred to as "Comma delimited files" that
contain the values in a table as a series of ASCII text lines
organized so each column value is separated by a comma from the next
column's value and each row starts a new line.

Instructions:

To use .csv Files: 

1) Open Excel 

2) Select File, Open 

3) In the "Open" dialog box, change the "look in" drop down menu to
the location where you downloaded the file;

4) Change the "Files of type" (bottom left corner) to "all files"; 

5) Select the file "name" and double click or click on the "Open" button. 

--Excel will then format cell-by-cell each variable based on the
contents (numeric or text) of the cell.

~~Cynthia

---

Request for Question Clarification by hummer-ga on 29 Aug 2006 17:34 PDT

Hi kbaboss,

Here's another way to do it.

Copy your word list and paste it into the first cell of excel
Select the cell & go to Data / Text to Columns / 
Choose Delimited 
Choose Tab & Comma
Finish

Your addresses should now each be in its own column.  
To change them into rows -

Copy them all.
Right-click the first cell which you will be using and click Paste Special
In the dialog box, select Transpose (right bottom), click OK.

I hope that helps!
hummer

......EASIEST SOLUTION ........
Assumed that you have opened microsoft word and that file
now
1. go to Replace(may be in edit->Replace)
2. in Find text box type   ,
[type comma only no need of space]

3. In replace type ^l
[don't use space]
or ^p whatever you like
4. Copy the content
5. open excel 
6. Paste the content
Check whether it works or not)