Regex - get data when multiple groups can exist within their own parentheses group

[alex]

Test line 1 (ABC) (DEF) - need DEF to be extracted

Test line 2 (GHIJ) (KL) (MNO) - need MNO to be extracted

Test line 3 (PQR) - need PQR to be extracted

If multiple groups of parentheses exist then need the last group.  I'd like for the data I need to be in the same column if possible.  Any help would be appreciated.

[binuacs · Accepted solution]

@alex One way of doing this

[alex]

(.+)(\<\w+\>) seemed to do the trick to just grab the last one.  Would like to see if could grab each group as well if they exist.

[grazitti_sapna]

@alex , You can use text to Columns in case of that as below:

[Felipe_Ribeir0]

hI @alex 

If by grabing each group you mean each group in a new column dynamically, here it is one way of doing this:

[alex]

Can you walk me thru the explanation of what the formula is doing.  Thanks!