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
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