Doing both right and left trims in the same cell at the same time

[livmun]

I have successfully used RIGHT/LEFT/LEN/MID in the past but can't get this one to work. I have a text string with numbers I want to extract but the text in front is varying lengths whereas the text behind is the same length. The numbers are enclosed by brackets with should make it easier but then there are some other words in brackets in some of the cells so the FIND didn't work there. All the numbers start with 4 so I can extract everything after 4 but still have the text after the numbers so, I can't think of a way to combine everything to leave just the numbers.
E.G.
hdjfhf (IP) (409) hgutns
hhhfg (499) hgutns
ty (IP) (455) hgutns

 

[Fluff]

One option
=MID(A11,FIND(4,A11),FIND(")",A11,FIND(4,A11))-FIND(4,A11))

 

[Rick Rothstein]

Are you numbers always 3-digits long? If so, try...

=0+MID(A1,FIND("(4",A1)+1,3)

otherwise try...

=0+MID(LEFT(A1,LEN(A1)-8),FIND("(4",A1)+1,LEN(A1))

 

[livmun]

One option
=MID(A11,FIND(4,A11),FIND(")",A11,FIND(4,A11))-FIND(4,A11))

You are a genius! Spot on thank you so much

 

[Fluff]

You're welcome & thanks for the feedback