Return Text from the Left of "("

Miles Allison

Hello,

I need to return a 11 characters from the left of a parenthesis from a string of text.

For example

T0000000001

T0000000002

T0000000003

(Primary Case)

I need the formula to return only the 11 characters from the left of "(Primary Case)"

T000000003

Nick Korna

Hi @Miles Allison,

If this text string is in a single cell, you can do this using:

=MID([Column Name]@row, FIND("(", [Column Name]@row) - 12, 11)

Obviously you need to change out "Column Name" for the header of the column the text is in, but this should work providing there is only a single instance of an open bracket in your text string.

Hope this helps!

Nick Korna

Hi @Miles Allison,

If this text string is in a single cell, you can do this using:

=MID([Column Name]@row, FIND("(", [Column Name]@row) - 12, 11)

Obviously you need to change out "Column Name" for the header of the column the text is in, but this should work providing there is only a single instance of an open bracket in your text string.

Hope this helps!

Miles Allison

That worked! thanks so much