Getting the string that follows the last occurrence of a character

With your sample data A1:A4
this regular formula, copied down, returns all of the text after the last ")" in the referenced cell

B1: =TRIM(RIGHT(SUBSTITUTE(A1,")",REPT(" ",LEN(A1))),LEN(A1)))

For your samples, these are the results in B1:B4

great great
omelette omelette
To get instant replies by our experts at nominal charges To get instant replies by our experts at nominal charges
ten, twelve ... ten, twelve ...

Is that something you can work with?

This formula should work as well. Someone else may be able to find a better method, however:

=MID(A1,FIND("("&(LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE(A1,")",""),"(","")))/2&")",A1)+4,LEN(A1))

This is also assuming your text starts in cell A1, but you can change the cell reference as needed.

Hope this helps!