Finding specific numbers in multiple characters

[computerdud]

Hi there, this has been driving me crazy. I receive raw data and I'm trying to sort it for inventory purposes; the cell looks like this:

08/24 Shifts: 08am-11am (30 projected)

<colgroup><col></colgroup><tbody>
</tbody>

I am looking to extract the number after the parenthesis and it's been giving me issues. In this case I would need the number 30. I do not need dates or shift times. Other cases:

07/18 Shifts: 05am-4pm (60-74 projected)

<colgroup><col></colgroup><tbody>
</tbody>

I could go with the range OR just the higher number. Any suggestions?

 

[Rick Rothstein]

Does this do what you want...

=REPLACE(LEFT(A1,FIND(" ",A1,FIND("(",A1))-1),1,FIND("(",A1),"")

 

[computerdud]

YESSSS RICK! Thank you so much! Perfect! i can stop hitting myself now!