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

christopherkiener

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.

Paul Newcome

Try something like this:

=IF(FIND("(", [Column Name]@row, FIND("(", [Column Name]@row) + 1) > 0, LEFT([Column Name]@row, FIND("(", [Column Name]@row, FIND("(", [Column Name]@row) + 1) - 1), [Column Name]@row)