RegExp function

Originally Posted by ramananhrm

Please try this function.

=SUBSTITUTE(SUBSTITUTE(RIGHT(SUBSTITUTE(A1,"(",REPT("!",LEN(A1))),LEN(A1)),"!",""),")","")

Thanks so much Ramananhrm! That works! It also works with many parentheses repeated before the text I wish to extract, so it's exactly what I wanted. Much appreciate!