Hello
I have a spreadsheet send to me and the only thing I need to do is extract 2 numbers
1. I need to extract numbers between the first( )to one cell then
2. I need to extract numbers between the second ( ) on a different cell.

this is an example of what I get on this spreadsheet from another individual.
example in Cell C2 Verizon(295)/AT&T(254) Keep in mind the numbers can change in digits 1,2,3,4

I Need to extract to cell
A5 295
A6 254

I was thinking left and right and mid maybe.

Help please thank you