Search Text

[sanju2323]

I need to Search word like shown as Column B

[sandy666]

try:

Please Login or Register  to view this content.

[samba_ravi]

What is your requirement / what is the problem with current excel file

[sanju2323]

Sir, I Am Trying your Formula but its not work, i need answer in Column "B".
=MID(A2,SEARCH("Zone",A2,1),LEN("Zone"))

[samba_ravi]

C2=IF(ISNUMBER(SEARCH(" "&B2&" "," "&A2&" ")),"Right","Wrong Search")
Try this and copy towards down

[sandy666]

in your example it works

B2: =MID(A2,SEARCH("zone",A2,1),LEN("zone"))

[samba_ravi]

then
b2=IF(ISNUMBER(SEARCH(" Zone "," "&A2&" ")),"Zone","")

[sanju2323]

nflsales, I am little bit Changes your formula but its work. thank you
=IF(ISNUMBER(SEARCH(" "&"Zone"&" "," "&A2&" ")),"Zone","")

[Ali Kırksekiz]

If Cell inludes Zonezone ??

Please Login or Register  to view this content.

[samba_ravi]

" "&"Zone"&" " will give " Zone "
booth are same

[sandy666]

nflsales, you formula doesn't work with text: *zone* or ?zone?

[sanju2323]

Also thank all those involved in this comment.