Comma separate keywords

[toddroutt]

Hi All

Any possible way I can use Excel to take a list of keywords in a vertical list, such as...

car
boat
tree
van
dog
cat
etc

Get it to insert commas behind each keyword...

car,
boat,
tree,
van,
dog,
cat,
etc,

Then enable me to extract in the following way...

car, boat, tree, van, dog, cat, etc,

Any help would be grately appreciated.

Cheers

Todd

[raypayette]

One easy way would be to tonvert it to a csv file that you couls import:

Please Login or Register  to view this content.

[toddroutt]

Hi Ray

I'm very, very new to Excel, and I have no idea how to use what you gave me, but, I'll do my best to figure it out.

Thank you kindly for shining light on this for me!

Todd

One easy way would be to tonvert it to a csv file that you couls import:

Please Login or Register  to view this content.