cell contains other cell's text - not a specific text

[hadar]

Hi all!

I will appreciate your help.

I need to find out if a certain cell contains other cell's text- it's not a specific text.

If A1 contains the text in C1....​

do you have any idea how to do that??

Another issue if you can figure out is the formulas I've tried so far couldn't identify if it's the same text when it was the same just with Caps lock letters ( Abc - abc).


please help me

 

[Aladin Akyurek]

Hi all!

I will appreciate your help.

I need to find out if a certain cell contains other cell's text- it's not a specific text.

If A1 contains the text in C1....​

do you have any idea how to do that??

Another issue if you can figure out is the formulas I've tried so far couldn't identify if it's the same text when it was the same just with Caps lock letters ( Abc - abc).


please help me

=ISNUMBER(SEARCH(C1,A1))+0

=(COUNTIF(A1,"*"&C1&"*")>0)+0

1 means yes, 0 no.

 

[hadar]

Thank you for your help but it isn't working...
Do you have other suggestion?

I will give an example..

[TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl65, width: 111"]A
Inside Logger
KieSoft
new deal

C
Inside Logger
kie
New [/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Thank you for your help but it isn't working...
Do you have other suggestion?

I will give an example..

[TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl65, width: 111"]A
Inside Logger
KieSoft
new deal

C
Inside Logger
kie
New [/TD]
[/TR]
</tbody>[/TABLE]

In D1 enter and copy down:

Either...

=ISNUMBER(SEARCH(C1,A1))+0

Or...

=(COUNTIF(A1,"*"&C1&"*")>0)+0

1 means: Yes, C1 is in A1; 0 No, C1 is not in A1.

 

[hadar]

Thank you!!! my mistake I wrote it a little bit different by mistake

 

[Aladin Akyurek]

Thank you!!! my mistake I wrote it a little bit different by mistake

You are welcome. Thanks for providing feedback.