Hi wonder if anyone can help I’ve looked all over before I post and can’t find exactly what I need, so I gotta lot of music that’s has the record label at the end of a track tag like this for example.
Moloko Bring it back (Davy Remix) smith records
So the record label is always after the closed brackets in this case smith records, I don’t want that information so I need a formula that will delete any text after the closed bracket “)”,
I’ve tried multiple formulas most are deleting the whole text in the field, cheers for any help