Return Text from the Left of "("

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

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!