excel search within left function results code example

Example: excel search from right

=IF(COUNTIF(A1,"* *"),RIGHT(A1,LEN(A1)-LOOKUP(LEN(A1),FIND(" ",A1,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A1),1))))),A1)

=IF(COUNTIF(A1,"*{{{YOUR SEARCH CHARACTER}}}*"),RIGHT(A1,LEN(A1)-LOOKUP(LEN(A1),FIND("{{{YOUR SEARCH CHARACTER}}}",A1,ROW(INDEX($A:$A,1,1):INDEX($A:$A,LEN(A1),1))))),A1)