Extract Text After First Space and Before (

[JamesA11]

Hello

I have a column of text strings that have a similar syntax in column B. Eg:

10cm error ORDER BOOK (3-1 sku99, 2-2 sku1198)

I would like to extract the text between the second space and the opening bracket (without the space before the bracket). So here it should be "ORDER BOOK".

Is this possible?

Thank you

 

[Peter_SSs]

Try this (even though your thread title says after first space)

=TRIM(REPLACE(LEFT(A1,FIND("(",A1)-1),1,FIND(" ",A1,FIND(" ",A1)+1),""))

 

[JamesA11]

Brilliant! Thank you Peter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.