Extract a number out of string

[madhatter40]

I'm trying to find a way to extract a number out of some strings. I only need the number to the left of ct. I used the following code that works but not for numbers above 99.

Please Login or Register  to view this content.

Example strings:

1/8 inch bolts 20ct
1/8 inch bolds 60ct
1/8 inch bolts 100ct

[CK76]

Something like below.

Please Login or Register  to view this content.

[AlKey]

Or this
Enter formula in C1 and copy down

Please Login or Register  to view this content.

v	B	C
1	1/8 inch bolts 20ct	20
2	1/8 inch bolds 60ct	60
3	1/8 inch bolts 100ct	100

[Ghozi Alkatiri]

formula array CSE
=MAX(IFERROR(--RIGHT(LEFT(A1,FIND("ct",A1)-1),ROW($1:$10)),0))