Search formula with continued text

[RPrasad]

[TABLE="width: 350"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]
Hi - need help on "Search" formula. Below is the example. When I put the search formula in B1 and B2 it shows the same result as the text continues

what I am looking is in B2 it should return error as "Term1" is not there in A2. could you please help how to do it? Thanks,

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Result in col B[/TD]
[/TR]
[TR]
[TD]Term1[/TD]
[TD]=SEARCH("Term1",A1)[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Term16[/TD]
[TD]=SEARCH("Term1",A2)[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mohadin]

Re: Help on search formula with continued text

Hi
Try

B1=FIND("Term1";A1)
B2=FIND("Term1";A2)

 

[RPrasad]

Re: Help on search formula with continued text

Hi tried the above code, still result is same.

as "Term1" contains in "Term16" the formula is reading only first few characters to match the result as son as it finds.

 

[Fluff]

Re: Help on search formula with continued text

How about
=SEARCH("Term1 ",A1&" ")