Text in cell E152: abc - India



1. formula1 applied on E152 (works correctly):

=TRIM(RIGHT(E152,(LEN(E152)-FIND("-",E152))))
==> output = India


2. formula2 applied on E152 (works correctly):

=ISNUMBER(SEARCH("India", E152))
==> output = TRUE

3. formula3 applied on E152 (doesn't work as expected):
replaced text "India" with formula in step 1

=ISNUMBER(SEARCH("TRIM(RIGHT(E152,(LEN(E152)-FIND("-",E152))))", E152))
==> output = FALSE (am expecting the output to be TRUE)