COUNT vowels

Hi makinmomb,

Try in B1 and copy down:

=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{"A","E","I","O","U"},"")))

Note - The substitute function is case sensitive, just in case any of your actual data is lower case?

Hope this helps.

Snook

Please Login or Register  to view this content.

Just an alternative (VBA equivalent) to the Snook's formula solution.