test for word

  • Thread starter Thread starter Vass
  • Start date Start date
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
 
You must log in or register to reply here.

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
COUNTIF formula? 1
lookup and return column number 2
Auto data entry 2
Macro to add Multiple rows in same sheet 1
Another Running Totals Problem 9
Pasting cell contents into a macro 1
max 7

Back
Top