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!

 

[sandy666]

with PowerQuery aka Get&transform

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]raw[/td][td][/td][td=bgcolor:#70AD47]Result[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]16-bit Enhanced (46ch)[/td][td][/td][td=bgcolor:#E2EFDA]46[/td][/tr]
[/table]

[SIZE=1]// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    TBD = Table.AddColumn(Source, "Result", each Text.BetweenDelimiters([raw], "(", "ch"), type text),
    ROC = Table.SelectColumns(TBD,{"Result"})
in
    ROC[/SIZE]

 

[Rick Rothstein]

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

Are the letters next to the number always "ch"?

 

[JoeMo]

Assuming the first instance of "(" in the string is in "(#ch), copy B1 down.

Excel Workbook
	A	B
1	16-bit Enhanced (46ch)	46
2	(3ch) 32-bit content	3
3	64-bit (128ch) control	128
4	nothing
Sheet1

 

[jtakw]

Hi,

Another option:

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,-LEFT(MID(A1,FIND("(",A1)+1,99),ROW($1:$15))),"")

Change/adjust cell references/range as needed, formula copied down.

 

[Rick Rothstein]

If, as JoeMo assumed, the letters after the number are always "ch", then here is another formula you can consider...

=IFERROR(0+MID(LEFT(A1,SEARCH("ch)",A1)-1),FIND("(",A1)+1,99),"")

otherwise use the formula jtakw posted.

 

[Russk68]

Thank you Sandy!

 

[Russk68]

Yes. I see some solutions that I am going to try.
Thank you!

 

[Russk68]

Works great!
Thanks Joe

 

[Russk68]

So many great options.
Thank you all!