It's not such a flexible solution, as it will only work if the text lengths are the same as your example. My solution is more flexible, as it allows any number of characters before the extracted text and up to 99 within the brackets. It gets rid of the final bracket by substituting it with a null value "".
To fully understand formulae, get into the habit of scrutinising them using Evaluate Formula on the Formulas ribbon.
You haven't yet marked the thread as solved.
Bookmarks