Regex to parse out text from last parentheses

Question

Hi, Thank you in advance for your help.

In the example below, the data may have multiple parenthesis and I would like to break them out into 2 columns where the last column is always the last parenthesis.

TitleRegexOut1RegexOut2Title 1 (A)Title 1(A)Title 2 (B) (C)Title 2 (B)(C)Title 3 (D) (E) (F)Title 3 (D) (E)(F)

SurferJim · Accepted Answer

Hi @AngelosPachis ,

Thank you but your solution only works partially in my real data.  I ended up looking for the pattern and insert a | delimiter.  Then I use Text to Column to separate out the string.