type this in c1
=IF(ISERROR(SEARCH(B1,A1)),"False","True")
case sensitive free
--
*Thanks & Regards
Thamu
*
On Mon, Feb 7, 2011 at 9:58 PM, rajan verma wrote:
> hello Mujeeb..
> find attached Sheet ..
>
> Rajan.
>
>
> On Mon, Feb 7, 2011 at 3:08 AM, Mujeeb wrote:
>
>> Hi team,
>>
>> Could y
hello Mujeeb..
find attached Sheet ..
Rajan.
On Mon, Feb 7, 2011 at 3:08 AM, Mujeeb wrote:
> Hi team,
>
> Could you pls help me in solving this excel formula.
>
> Eg;
>
> If A1 has some text for eg " My name is Google"
> In B1 if we type any text from A1, Eg "name " C1 should appear as
> TRUE.
Hi Mujeeb,
attach an excel sheet with example.
Reg
Umesh
On Mon, Feb 7, 2011 at 4:38 PM, Mujeeb wrote:
> Hi team,
>
> Could you pls help me in solving this excel formula.
>
> Eg;
>
> If A1 has some text for eg " My name is Google"
> In B1 if we type any text from A1, Eg "name " C1 should appe
TYPE THSI IN C1
=IF(ISNUMBER(FIND(B1,A1)),TRUE,FALSE)
On Mon, Feb 7, 2011 at 4:38 PM, Mujeeb wrote:
> Hi team,
>
> Could you pls help me in solving this excel formula.
>
> Eg;
>
> If A1 has some text for eg " My name is Google"
> In B1 if we type any text from A1, Eg "name " C1 should appear as
Hi team,
Could you pls help me in solving this excel formula.
Eg;
If A1 has some text for eg " My name is Google"
In B1 if we type any text from A1, Eg "name " C1 should appear as
TRUE.
If we type text which is not in A1 Eg "yahoo" C1 should appear as
FALSE.
Note : A1 must be changeable and I
