Splitting a column in CSV to multiple columns

Hi,

We have a CSV thats an export from a database, the database handles addition form fields as 'extended fields' and lumps them all into 1 cell on export.

We need to split this cell into multiple cells to help our customer as its no use as it remains.

Im a total newbie to the functions of Excel other than the basic sums and formulas and need a Macro or something to help split the field.

The construction of the cell data is as follows:

{"surname":"Smith","product":"Product Name","newsletter":"Yes"}

and needs splitting into the columns of 'Surname' Product and Newsletter

Thanks for your help.

I thought i had

attached - it will nees the .xls removing.

Thanks

That might help

Please see attached.