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
drop down lists 2
Table of Contents - How do I ? 2
drop down list box 1
Unable to identify appropriate formula for very simple scenario 2
Auto complete from Checkbox/Other? 0
IF function to return date content of another cell 7
Parsing, separating, inserting. copying 2

Top