RIGHT with Optional text

[JTL9161]

I have the following formula: =RIGHT(F2,LEN(F2)-SEARCH("+",F2))

Which takes the text after a "+"(plus sign)

Is there a way to make the formula work for both a "+" (plus sign) AND/OR a "-" minus sign

Either one will be in the cell.

Thanks,
James

 

[dreid1011]

Maybe this:

=RIGHT(F2,LEN(F2)-IFERROR(SEARCH("+",F2),SEARCH("-",F2)))

 

[JTL9161]

You got it! Thanks

 

[AhoyNC]

Try with Excel 365:

Book1
	A	B	C
1	Test + a plus sign		a plus sign
2	Test2 - next text		next text
Sheet1

Cell Formulas
Range	Formula
C1:C2	C1	=TEXTAFTER(A1,{"+","-"})