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:

[TABLE="width: 606"]
<colgroup><col></colgroup><tbody>[TR]
[TD]08/24 Shifts: 08am-11am (30 projected)
[/TD]
[/TR]
</tbody>[/TABLE]


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:

[TABLE="width: 606"]
<colgroup><col></colgroup><tbody>[TR]
[TD]07/18 Shifts: 05am-4pm (60-74 projected) [/TD]
[/TR]
</tbody>[/TABLE]


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!