Can excel insert commas in a new list?

[kevs]

I have a one column list of many keywords. One or two words per cell.

But now I need that list to be entered into a website field for keywords.

And each keyword need a comma between each word.

So, is there any way, instead of me having to insert all those commas one by
one, which we can tell excel to paste all those words in the column to a
word file, or a web page... With commas in between each word. Thanks!




OS 10.4.6
Office 2004

 

[Edwin Tam]

I think, you have a list words. Some cells contain more than one word. In
case for those with more than one word, you would want to have a comma
between each word.

You can use the Find/Replace feature of Excel to do this.

In "Replace", you can define the "Find What" and "Replace with".
You can tell Excel to find a space (just type an empty space in the edit
box), and replace with a comma plus a space. (type a comma followed by a
space)
Click OK.


Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[kevs]

Edwin:
Thanks
With cells that had two words, this trick inserted a comma between the two
words, (which I don't want actually) but all the others in had no effect,
and I was surprised being that all the others had lot of space to the right
of the single word. The rest were all single words

Kevs

I think, you have a list words. Some cells contain more than one word. In
case for those with more than one word, you would want to have a comma
between each word.

You can use the Find/Replace feature of Excel to do this.

In "Replace", you can define the "Find What" and "Replace with".
You can tell Excel to find a space (just type an empty space in the edit
box), and replace with a comma plus a space. (type a comma followed by a
space)
Click OK.


Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

OS 10.4.6
Office 2004