May 17 2019 09:25 AM
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?
May 17 2019 09:34 AM
@larrymcfarland , you may extract what is in brackets by
=MID(A1,SEARCH("(",A1)+1,LEN(A1)-SEARCH("(",A1)-1)
May 17 2019 09:39 AM
Thank you Sergei. That is exactly what I needed. @Sergei Baklan