On Tue, 3 Jul 2007 02:08:01 -0700, T.Mad
wrote:

Hi all
I wonder if you can help me with a query I have. I want to find the number
of cells in a row (for example row A) which contain the word London. The
problem is that in some cell the word is contained as part of other text so
if for example the cell A1 contains the text “50 Kingsway, London, WC1” the
function =if(A1="London",1,0) returns the value of 0 failing to capture the
word “London” which is contained in the cell. Can you propose a solution? Can
I do that with VB?
The problem is that I have a spreadsheet with 80,000 cells in row A so I
need to have 80,000 cells in row B that will check the values of row A (eg B2
will perform the check in A2). This would make my desktop really slow to
perform the checks. Can you help with that issue as well? Thank you in
advance.



One way is to use wild cards in the COUNTIF function:

=COUNTIF(rng_to_check,"*London*")


--ron