![]() |
#1
|
|||
|
|||
![]()
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) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rajeshn_in | Excel | 1 | 01-09-2017 03:59 AM |
![]() |
bendmc | Excel | 2 | 11-17-2016 11:31 AM |
![]() |
babs1234 | Excel | 3 | 03-04-2015 06:08 AM |
![]() |
Dkline | Excel | 3 | 06-04-2014 06:40 AM |
![]() |
Manny | Word | 1 | 09-30-2013 03:39 PM |