If formula for searching for a specific alpha character in a cell.

[klitton7]

I need help with a formula. Here's the logic.
If the cell contains a ")" at the end,
then give me the alpha character that comes right after the "("

In some cases, there is a a "(" at the very beginning of the text. The first example has this scenario.
See attachment and expected results in column to right.

Thank you.

 

[MountainFog]

=LET(a,TEXTAFTER(A1,"(",-1),IF(RIGHT(a,1)=")",LEFT(a,1),"NOT FOUND"))

 

[klitton7]

Thanks - I just tried and result is: NAME?
Maybe I'm doing something wrong.

 

[klitton7]

Sorry - result is: #NAME?

 

[Fluff]

Maybe I'm doing something wrong.

No your not.

@MountainFog Please take more care when posting solutions & ensure they will work with the version of Excel that the OP is using.

 

[hagia_sofia]

Hello, would the following address the issue:

=IFERROR(MID(A1,FIND("##",SUBSTITUTE(A1,"(","##",LEN(A1)-LEN(SUBSTITUTE(A1,"(",""))))+1,1),"")

 

[klitton7]

Thanks hagia_sofia. I apologize for the delay. I will test the formula as soon as I can.

 

[klitton7]

PERFECT! Thank you!

 

[hagia_sofia]

Many thanks for the feeback and we are glad we could help!