test for word

V

Vass

Can anyone assist me please

I'd like a column of cells to report the instance of a certain word in a
line of text in the column cells to the left

i.e. Find all instances of "apple" in the cells below

he had a apple
an apple was here
oranges only
three apples here

Even if like in the 4th cell the word is "apples" it should still pick it up

any ideas please ?

thanks

--
Vass
................................................
Now: YZF-R1, CBR1100xx-x
Then: A100, MBX80, XL125, CB400, FZR600, CBR600Fv
email: Remove Bra to reply
 
Top