How do I remove the text between the second set of parenthesis in a cell?

Options

for example: Tinley Park North (IL) FSU (Tinley Park, IL).

Input: Tinley Park North (IL) FSU (Tinley Park, IL)

Desired Output: Tinley Park North (IL) FSU

I need a formula that can return the desired output but if false then returns the original value of the cell.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!