Hi,
I have a cell that contains the following information.

4 ran TIME 1m 0.90s (slow by 3.90s) Total SP 108%
or
12 ran TIME 1m 0.90s (Fast by 3.90s) Total SP 108%
this information could be anywhere in column B although I can get this to a say cell A1

I want to take the information in brackets (slow by 3.90s) or (fast by 3.90s) and return it in another cell as 3.90 or -3.90 respectively.


Thank you for any help you can offer me.

Regards,

Richard.