Searching Cells in Excel
 

I need to set up a search function in Excel so that it can idetify a given
word in a sentence, which is written in one cell. For example,

If Cell A1 is the place where the word you are looking for is written.

Then in Cell B1 the following sentence is written: "I like playing
football".

If the user puts in "football" in cell A1, I need it to return a true for B1
because it regonises "football" in the sentence.

--
Duncan

Searching Cells in Excel
 

Duncan:

example:

Dim f As Variant
Dim checktxt As Boolean
Range("A1").Select
f = Split(Range("B1"), " ")
For i = 0 To UBound(f)
If f(i) = Range("A1") Then
checktxt = True
Exit For
Else
checktxt = False
End If
Next i
MsgBox checktxt


--
天行å�¥ï¼Œå�›å*�以自強ä¸�æ�¯
地勢å�¤ï¼Œå�›å*�以厚德載物

http://www.vba.com.tw/plog/


"Duncan" wrote:

I need to set up a search function in Excel so that it can idetify a given
word in a sentence, which is written in one cell. For example,

If Cell A1 is the place where the word you are looking for is written.

Then in Cell B1 the following sentence is written: "I like playing
football".

If the user puts in "football" in cell A1, I need it to return a true for B1
because it regonises "football" in the sentence.

--
Duncan

Searching Cells in Excel
 

if you need to know if the word present in cell A1 is in the cell B1
text you can put this formula in cell C1:
=FIND(A1,B1,1)


--
antoka05
------------------------------------------------------------------------
antoka05's Profile: http://www.excelforum.com/member.php...o&userid=29024
View this thread: http://www.excelforum.com/showthread...hreadid=487562

Searching Cells in Excel
 

Thank you very much for your swift reponce. This sounds like the right
formula, but its just returning a number 16. I need it to say True if it
appears in the sentence, or a " 1" will do
--
Duncan


"antoka05" wrote:


if you need to know if the word present in cell A1 is in the cell B1
text you can put this formula in cell C1:
=FIND(A1,B1,1)


--
antoka05
------------------------------------------------------------------------
antoka05's Profile: http://www.excelforum.com/member.php...o&userid=29024
View this thread: http://www.excelforum.com/showthread...hreadid=487562