stuck on removing specific text

[kurigami]

Hi everyone.

I'm trying to remove a specific character ")" however, I need it to fit within my existing formula if at all possible. The formula already identifies "(" and removes the character plus everything left of it. I know that the substitute function is probably best here (either that or RIGHT, but the last character isn't always a ")" so I don't think I want to go that route), but I can't quite figure out where to fit it in. Here's what I have currently:

=IF(A2="","",IFERROR(RIGHT(B2,LEN(B2)-FIND("(",B2)),IFERROR(VLOOKUP(A2,'Org Chart'!$E$2:$F$526,2,FALSE),"Rep not found in snapshot")))

Thanks for your help!

 

[Eric W]

If I understand this, if there's something in B2 and it has parentheses in it, you want to just show the part in the parentheses? And if there are no parentheses in B2, you use VLOOKUP to find something else? Will there ever be more than one set of parentheses?

 

[Eric W]

You can replace this part of your formula:

RIGHT(B2,LEN(B2)-FIND("(",B2))

with:

RIGHT(LEFT(B2,FIND(")",B2)-1),FIND("(",B2)+1)