Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

Hit Ctrl+F.From Find window click on 'Options'. Make sure you check 'Match
entire cell contents' and then do the find.

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

If you are looking for a word match within a cell then add a space at the
beginning and end
Find what: ' Vision '


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hit Ctrl+F.From Find window click on 'Options'. Make sure you check 'Match
entire cell contents' and then do the find.

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

Sorry, it cannot work. It says: "Microsoft Office Excel cannot find the data
you're searching for." Is there any way?

"Jacob Skaria" wrote:

If you are looking for a word match within a cell then add a space at the
beginning and end
Find what: ' Vision '


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hit Ctrl+F.From Find window click on 'Options'. Make sure you check 'Match
entire cell contents' and then do the find.

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

If you are searching for a word match like 'vision' uncheck 'Match entire
cell contents' and find ' vision 'FindAll... which will list down cell
references which is having a full word 'vision' in between sentences.

'with 'Match Case' checked
'Vision '

'sentences ending with vision.
' vision.'

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Sorry, it cannot work. It says: "Microsoft Office Excel cannot find the data
you're searching for." Is there any way?

"Jacob Skaria" wrote:

If you are looking for a word match within a cell then add a space at the
beginning and end
Find what: ' Vision '


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hit Ctrl+F.From Find window click on 'Options'. Make sure you check 'Match
entire cell contents' and then do the find.

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

Still no help. It still finds words containing 'vision', like division, etc.
Well, I now understand that excel does not have such a function. Anyway,
thank you for your help, Jacob Skaria.

"Jacob Skaria" wrote:

If you are searching for a word match like 'vision' uncheck 'Match entire
cell contents' and find ' vision 'FindAll... which will list down cell
references which is having a full word 'vision' in between sentences.

'with 'Match Case' checked
'Vision '

'sentences ending with vision.
' vision.'

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Sorry, it cannot work. It says: "Microsoft Office Excel cannot find the data
you're searching for." Is there any way?

"Jacob Skaria" wrote:

If you are looking for a word match within a cell then add a space at the
beginning and end
Find what: ' Vision '


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hit Ctrl+F.From Find window click on 'Options'. Make sure you check 'Match
entire cell contents' and then do the find.

If this post helps click Yes
---------------
Jacob Skaria


"Jack" wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

On Fri, 27 Nov 2009 23:51:01 -0800, Jack
wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

How is your dictionary structured?
--ron

Very simple. I arrange Mongolian words (I am from Mongolia) in column A and
their English translation in column B. So far, I have 12693 rows, which make
me hard to find short and repeated words, like profit, air, vehicle, etc.

"Ron Rosenfeld" wrote:

On Fri, 27 Nov 2009 23:51:01 -0800, Jack
wrote:

Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I want
to find only the word 'vision' in order not to waste time, finding unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

How is your dictionary structured?
--ron
.

On Sat, 28 Nov 2009 07:24:01 -0800, Jack
wrote:

Very simple. I arrange Mongolian words (I am from Mongolia) in column A and
their English translation in column B. So far, I have 12693 rows, which make
me hard to find short and repeated words, like profit, air, vehicle, etc.

Will a word appear by itself? In other words, if you are looking for

vision

do you also want to find cells that contain, for example:

vision; sightings

??

--ron

That's right. For example, I have 'vision' in the following cells (rows):
- vision statement
- hallucination of vision
- to lose one's vision as he/she ages
- field of vision, etc.

In order to find just 'vision,' I have to search through the following cells
(rows), wasting time:
- Geology and Mining Cadastre Division (many other cells that contain
'division')
- divisional commander, divisional structure
- political subdivision
- administrative supervision
- provision
- television
- provisional invoice, and so many words.

I hope you understand my problem from the above.

"Ron Rosenfeld" wrote:

On Sat, 28 Nov 2009 07:24:01 -0800, Jack
wrote:

Very simple. I arrange Mongolian words (I am from Mongolia) in column A and
their English translation in column B. So far, I have 12693 rows, which make
me hard to find short and repeated words, like profit, air, vehicle, etc.

Will a word appear by itself? In other words, if you are looking for

vision

do you also want to find cells that contain, for example:

vision; sightings

??

--ron
.

The following macro will do what you want; just change the assignments in
the two Const (constant) statements at the beginning of the code to the
worksheet name and column letter that want to search in. If you want, you
can attach the macro to a button (either on the worksheet or the toolbar) to
make accessing it easier. The macro will ask you for the word or phrase you
want to find (letter casing is not important) and then locate it if it
exists in the list (or tell you that the word or phrase could not be
found)... after finding the first occurrence of the word or phrase, you will
be given the opportunity to look for its next occurrence in case the first
occurrence was not the one you wanted. This continued searching will not end
until you click the No button on the dialog box that asks you about
continuing the search.

Sub FindExactWord()
Dim C As Range, FindWord As String, Answer As Long
Const SearchColumn As String = "B"
Const WorksheetName As String = "Sheet1"
FindWord = InputBox("What word do you want to find?")
With Worksheets(WorksheetName)
Set C = .Columns(SearchColumn).Find(FindWord, LookIn:=xlValues, _
LookAt:=xlPart, After:=Cells(.Rows.Count, "B"), _
MatchCase:=False, SearchDirection:=xlNext)
If Not C Is Nothing Then
Do
If " " & UCase(C.Value) & " " Like "*[!A-Z]" & _
UCase(FindWord) & "[!A-Z]*" Then
C.Select
Answer = MsgBox("Continue searching?", vbQuestion Or vbYesNo)
If Answer = vbNo Then Exit Do
End If
Set C = .Columns(SearchColumn).FindNext(C)
Loop
Else
MsgBox "I could not find """ & FindWord & """."
End If
End With
End Sub

--
Rick (MVP - Excel)


"Jack" wrote in message
...
Hello, everybody!

I have a dictionary that I created in excel and that is becoming too large
to find particular words. I have one problem with finding. I want to find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I
want
to find only the word 'vision' in order not to waste time, finding
unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack

Here is a slight modification to my macro so that the FindWord surrounded by
numbers is not considered a stand-alone word...

Sub FindExactWord()
Dim c As Range, FindWord As String, Answer As Long
Const SearchColumn As String = "B"
Const WorksheetName As String = "Sheet1"
FindWord = InputBox("What word do you want to find?")
With Worksheets(WorksheetName)
Set c = .Columns(SearchColumn).Find(FindWord, LookIn:=xlValues, _
LookAt:=xlPart, After:=Cells(.Rows.Count, "B"), _
MatchCase:=False, SearchDirection:=xlNext)
If Not c Is Nothing Then
Do
If " " & UCase(c.Value) & " " Like "*[!A-Z]" & _
UCase(FindWord) & "[!A-Z0-9]*" Then
c.Select
Answer = MsgBox("Continue searching?", vbQuestion Or vbYesNo)
If Answer = vbNo Then Exit Do
End If
Set c = .Columns(SearchColumn).FindNext(c)
Loop
Else
MsgBox "I could not find """ & FindWord & """."
End If
End With
End Sub

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
The following macro will do what you want; just change the assignments in
the two Const (constant) statements at the beginning of the code to the
worksheet name and column letter that want to search in. If you want, you
can attach the macro to a button (either on the worksheet or the toolbar)
to make accessing it easier. The macro will ask you for the word or phrase
you want to find (letter casing is not important) and then locate it if it
exists in the list (or tell you that the word or phrase could not be
found)... after finding the first occurrence of the word or phrase, you
will be given the opportunity to look for its next occurrence in case the
first occurrence was not the one you wanted. This continued searching will
not end until you click the No button on the dialog box that asks you
about continuing the search.

Sub FindExactWord()
Dim C As Range, FindWord As String, Answer As Long
Const SearchColumn As String = "B"
Const WorksheetName As String = "Sheet1"
FindWord = InputBox("What word do you want to find?")
With Worksheets(WorksheetName)
Set C = .Columns(SearchColumn).Find(FindWord, LookIn:=xlValues, _
LookAt:=xlPart, After:=Cells(.Rows.Count, "B"), _
MatchCase:=False, SearchDirection:=xlNext)
If Not C Is Nothing Then
Do
If " " & UCase(C.Value) & " " Like "*[!A-Z]" & _
UCase(FindWord) & "[!A-Z]*" Then
C.Select
Answer = MsgBox("Continue searching?", vbQuestion Or vbYesNo)
If Answer = vbNo Then Exit Do
End If
Set C = .Columns(SearchColumn).FindNext(C)
Loop
Else
MsgBox "I could not find """ & FindWord & """."
End If
End With
End Sub

--
Rick (MVP - Excel)


"Jack" wrote in message
...
Hello, everybody!

I have a dictionary that I created in excel and that is becoming too
large
to find particular words. I have one problem with finding. I want to
find,
for example, 'vision,' but it finds all words containing 'vision,' i.e.
division, divisional, visionary, provision, etc. What I need is that I
want
to find only the word 'vision' in order not to waste time, finding
unrelated
words, as mentioned above.

Is there any solution to it? Please help me.

Thanks in advance.
Jack