I have records that are automatically created in my base. Some of them end in the phrase “(X of Y)” to indicate they are one of many. Others do not have this tag at all.
I need help creating a formula that removes all instances of this parenthetical count. This would give me ability to group all records with identical names:
Kelly’s Record (1 of 2)
Kelly’s Recors (2 of 2)
----> all turn in to “Kelly’s Record”
However, I need the formula to leave unique records unaffected:
Kelly’s New Record
—> Kelly’s New Record