How get my column seperated by commas?

[kevs1]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have a column of a thousand names. I need to get these names on a word document seperated by commas. Possible? I tried text to columns but could not achieve it. thanks

 

[CyberTaz]

Once again kevs you give just enough info that there is no way to answer the
question effectively How many names doesn't make any difference. What
you need to do is accurately describe exactly how the names are stored in
the Excel file as well as exactly how you want them to appear in the Word
document, including *where* the commas are supposed to go.

The right answer depends on those factors, but there are several approaches
that hang on each possible combination.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs1]

Bob, check out screenshots.
I have an excel column as you see.
I want the word document as you see:

 

[kevs1]

<a href="http://tinypic.com <http://tinypic.com>" target="_blank"><img src="http://i40.tinypic.com/2rdkyzq.jpg <http://i40.tinypic.com/2rdkyzq.jpg>" border="0" alt="Image and video hosting by TinyPic"></a>

 

[kevs1]

<http://i40.tinypic.com/2rdkyzq.jpg>"

"http://i40.tinypic.com/2iwazb4.jpg <http://i40.tinypic.com/2iwazb4.jpg>" border="0" alt="Image and video hosting by TinyPic"></a>

 

[kevs1]

Sorry, for bad links, but Image Shack is not charging, and testing new image upload site. how you see the two screenshots, one for excel, one for word

 

[kevs1]

<http://tinypic.com/r/2iwazb4/5>

<http://i40.tinypic.com/2iwazb4.jpg>

 

[CyberTaz]

OK, that helps a bit

Select & copy the list in Excel, go to an empty row, then to Edit> Paste
Special. Check the Transpose box & click OK.

Go to your Word doc & paste, which will create a Table with each name in a
separate cell. Click in the table then go to Table> Convert> Convert Table
to Text, choose the Comma option as the Separator, then OK.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs1]

Bob, thanks, I'm going everything you say but not working.
I got the table with all the names in their individual cells in word.
I do convert table to text and select commas. Then I have a column with all the names, but no commas. Just a column with names in word.
Very puzzling it's not putting in the commas. They are acutally are not names, but email addresses, I wonder if that' an issue.

 

[CyberTaz]

I don't see that the email addresses should make any difference -- and it
doesn't make a difference here so there must be something else you're
leaving out. However, if you have the list pasted into a Word doc try this;

First, turn on the non-printing characters (¶) -- does one appear next to
each address in the column? If so and there isn't any other content in the
document go to Edit> Replace.

In the Find what: box type ^p
In the Replace with: box type ,
Click Replace All

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs1]

Bob,
how do I turn on non-printing characters? I looked in menu and can't find it.
I searched help and nothing useful comes up for that.

 

[CyberTaz]

Look for the ¶ symbol on Word's Standard Toolbar or key Cmd+8 to toggle
their visibility on/off.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs1]

Bob, I see this symbol
<http://tinypic.com/r/2uivig0/5>

after each email address (in it's own cell) and then at the outside of the cells too.
I have no idea what that means.

I followed what you said to do, although I did not understand it at all, and it did not work.

I then did a find for ^p
(that is the symbol above the 6 key -- whatever that is, and p.
Then replace with , a comma.
NOthing happened.
Of course, I have no idea what's going on there, or I'm going it right. it's very nebulous and convoluted.

 

[CyberTaz]

Your "list" is still in a table -- those symbols are end of cell & end of
row markers -- so you still need to convert the table to text.

1- Click in the table
2- Go to Table> Convert> Convert Table to Text (don't worry about the
"Comma" option, just click OK)
3- Then do the Find & Replace as you did before

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs1]

Ok, I think that worked, thanks!