View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jack jack is offline
external usenet poster
 
Posts: 186
Default How to find a particular word?

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
.