Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
searching 2 values from 2 cells | Excel Discussion (Misc queries) | |||
Searching for Linked Cells | Excel Discussion (Misc queries) | |||
Searching a cells contents? | Excel Worksheet Functions | |||
Searching for string in other cells | Excel Worksheet Functions | |||
Is there any way of searching for duplicate cells? | Excel Discussion (Misc queries) |