Excel - Data search and count within a cell

A

Alan

Lets say Cell A1 contains the following text string:

"Hello Yellow Mellow"

How do I count the total number of L's in that cell

Find and Search functions simply return the first instance
but not the number of occurances.

Any ideas. Please suggest away.

Cheers
Alan
 

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

Counting coloured cells 3
Counting the number of times a character occurs in a cell 1
count nonblank cells 3
count - but exclude counting cells with a formula 4
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Count the words in a cell 8
Counting Occurrence of a Value within Cells 1
counting no. of times a character occurs in a cell 3

Top