Parsing a string & shifting data selectively

[gmr324]

I have a csv file which was generated by exporting data from the SEO Quake Firefox plugin. However all the data was deposited into one column as a string. I'd like to parse and shift some of the data into another column. The SEO Quake Firefox plugin exported the following data into one column. The data is a URL and a number which represents the page rank of the URL as follows:

http://www.oasisnyc.net/;"6"

What I need to do is remove the ( semi-colon and shift just the number (in this case 6) into the next column B

So, the end result from that string of data in column A is the url (http://www.oasisnyc.net) in column A and the number 6 in column B.

How can I accomplish this parsing and data separation?

Thanks

George

[ken johnson]

Select the text in column A then go Data|Text to Columns... to bring up the "Text to Columns" dialogue.
Tick the "Other" checkbox under the "Separated by" heading then enter a semicolon followed by a double quote (;") into the textbox immediately to the right, then tick the "Merge delimiters" checkbox then click OK.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).