extracting data from a string

[Longball]

Thanks for your help in advance. Here is the deal. I get data off the internet that comes in long strings. I need to extract data out and assign them to columns. if the string looks like this:
Smith, Larry England -3,2
I need to get Smith as LAST NAME, Larry as FIRST NAME, England as COUNTRY, and -3,2 as HANDICAP. I already have the LAST NAME and HANDICAP figured out, it is the FIRST NAME and COUNTRY that are killing me. IDEAS??

 

[Trouttrap2]

Can you use the Text to Columns built in the toolbar. If using Excel 2003 select your data then tap Alt+D+E
Then select fixed width. This will put your text string into separate columns.

 

[CWatts]

Depending on how it's formatted on the internet, have you tried using excel's external data functionallity?