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

klitton7

New Member
Joined
Jul 24, 2024
Messages
24
Office Version
  1. 2019
Platform
  1. Windows
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.
 

Attachments

  • Screenshot 2024-10-23 135856.png
    Screenshot 2024-10-23 135856.png
    10.2 KB · Views: 11

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Excel Formula:
=LET(a,TEXTAFTER(A1,"(",-1),IF(RIGHT(a,1)=")",LEFT(a,1),"NOT FOUND"))
 
Upvote 0
Thanks - I just tried and result is: NAME?
Maybe I'm doing something wrong.
 
Upvote 0
Hello, would the following address the issue:

Excel Formula:
=IFERROR(MID(A1,FIND("##",SUBSTITUTE(A1,"(","##",LEN(A1)-LEN(SUBSTITUTE(A1,"(",""))))+1,1),"")
 
Upvote 0
Solution
Thanks hagia_sofia. I apologize for the delay. I will test the formula as soon as I can.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top