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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coloured Tabs 2
IF function to return date content of another cell 7
transpose the code from "rows" to "columns" 4
how to make a word idenifications show up as numbers 6
Parsing, separating, inserting. copying 2
Counting occurrences of a word in cells in which there are multiple words 2
vlookup on first occurrence of X after Y? 3
Conditional Median 2

Top