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


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!