Trim numbers seperated by commas in a bracket

Hi

Could someone give me help with the following:

I'm trying to trim each specific number in this list:

{1998.054,1998.358,1998.669,1998.989,1999.318,1999.655,2000,2000.354,2000.716,2001.087}

i.e. one cell i want to have just 1998.054

And the next cell have 1998.358

Thanks for your help

You could use Find & Replace (twice) to change those brackets to nothing.

Hope this helps.

Pete

Well this is the equation I have at the moment:

LEFT(TRIM(LEFT(SUBSTITUTE(MID(B4,FIND("{",SUBSTITUTE(B4,",","|",2))+1,LEN(B4)),",",REPT(" ",LEN(B4))),LEN(B4))),LEN(B4)-FIND(",",SUBSTITUTE(B4,",","a",1))-1)

But I cant get it to find the next number in the string. i.e. betwene the next set of commas.