Need formula t0 extract # between ()

[Russk68]

Hello all
I need to extract the number like in the example below.
Between the () is always (#ch).

Before: 16-bit Enhanced (46ch)
After: 46

Thank you!

 

[DanteAmor]

Other options:

If the data (#ch) is at the end of the text, it can be with this:


=IFERROR(SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),"ch)","")+0,"")


Otherwise with this:

=IFERROR(LEFT(SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),"ch)",REPT(" ",250)),99)+0,"")

 

[jtakw]

So many great options.
Thank you all!

You're welcome, thanks for the feedback.

Just realized the LEFT function isn't needed in my formula from Post # 5, can be just:

Book1
	A	B
1	16-bit Enhanced (46ch)	46
2	32-bit (144ch)	144
3	64-bit (299 not specified)	299
4	nothing
5	(3ch) 32-bit content	3
Sheet701

Cell Formulas
Range	Formula
B1	=IFERROR(-LOOKUP(1,-MID(A1,FIND("(",A1)+1,ROW($1:$15))),"")