Excell and CSV

P5 changed the way the keywords were separated a long time back. On the csv I have a very large number that are separated by "spaces" and the newer few thousand are separated by "comas".

Can someone help me if there is a way within Excel to change the keywords in the csv file to be all coma separated without having to insert comas one at a time. Is there a way to do it?
Thanks

You can click on the keywords column. Then go to edit, find. In the popup box click on the replace button.
In the find field just press the space bar to put a space in it.
In the replace field type in a comma. They press replace all.

This may put two commas. Then just do the same thing but in the find field type two commas and in the replace field type in one comma.

I'll give it a try, thanks Jake.

No problemo
(that's Spanish)

Thanks it workedo ;)

I need to brush up on my Spanish. Took me a while to figure that one out.

Glad it worked.

Just a note of caution - using this method will screw up keyphrases in quotes. For example:

keyword “double word” keyword

would be changed to:

keyword,“double,word”,keyword

Good point.

I suggest to ask Marcus to include the 'Export to ASCII CCV' option in My Uploads -> Actions. Everyone will be happy then.
Zygis

How would the following work for you?
1. select the column(s) where the data are
2. go to the top menu of excel, click on Data > Text to Columns
3. when the wizard pops-up, keep the selection at Delimited, hit next
4. at the next screen, uncheck anything that may be checked and only check "Comma"
5. hit next, then finish

Let me know how that works for you.