Get Text Between Two Characters in String

[andybason]

Hi,

I have a string that varies in length and format in cell A10. I want to get the text that is always immediately after ( and before the first space after the bracket.

Eg. Model: 291V : xxx1 (111-999 Ultra HD, 111-888 QSpec)

Here I would like the text 111-999.

Can this be done?

Thanks

 

[Fluff]

How about

=MID(A10,FIND("(",A10)+1,FIND(" ",A10,FIND("(",A10))-FIND("(",A10)-1)

 

[Joe4]

Here is one way:

=TRIM(LEFT(SUBSTITUTE(MID(A10,FIND("(",A10)+1,LEN(A10))," ",REPT(" ",100)),100))

 

[shaowu459]

Office 365：
=LET(a,MID(A10,1+FIND("(",A10),99),LEFT(a,FIND(" ",a)-1))

 

[Fluff]

@shaowu459 The OP is using 2016, so that will not really help.

 

[andybason]

Thank you all. Lots of ways to skin this cat!

 

[Fluff]

Glad we could help & thanks for the feedback.