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)

In formula 3 why did you put double quotes before TRIM and after closing the SEARCH function?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yeah, it worked after removing the double quotes.

Can you check my another query @https://www.msofficeforums.com/excel/34725-use-varilable-vba-excel-formula.html

I'm sorry I'm no VBA man. I will marked this thread solved

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post