Splitting data

[larrymcfarland]

I receive data in the following format 

C-3.00D-3.00P-0.00O-0.00(T-3.00)

and only need T-3.00.  How do I get rid off the unwanted data?

[#2]

@larrymcfarland , you may extract what is in brackets by

=MID(A1,SEARCH("(",A1)+1,LEN(A1)-SEARCH("(",A1)-1)

[#3]

Thank you Sergei.  That is exactly what I needed. @Sergei Baklan 

[#4]

@larrymcfarland , you are welcome