Pull numeric from text

[makinmomb]

spoons (6)
Tea spoons (6)
forks (6)
knives (6)
Can opener (1)
Chopping board (1)
Frying pan (1)
Plates (6)
Mugs (6)
Glasses (6)

I got this on a1 downwards , need formula on b1 to give me those numerics

[makinmomb]

expected result will be

6
6
6
6
1
1
1
6
6
6

[fanfaanfann]

=abs(value(right(a1;3)))

[davsth]

in your sample no numbers are greater than 1 digit however they could be?

=MID(A1,SEARCH("(",A1,1)+1,LEN(A1)-SEARCH("(",A1,1)-1)*1

if you want it as a number

[makinmomb]

davsth yours working , thank you