Try this:

=SUMPRODUCT(--(LEN(A1:Z1)2))

And copy down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"sks1379" wrote in
message ...

Hi,
My requirement is thus...
I have multiple rows with one word in each cell...at the end of each
row i need to find the number of words in that particular row whose
length is greater than 2.
Any thoughts please?
Thanks
Kiran.


--
sks1379
------------------------------------------------------------------------
sks1379's Profile:
http://www.excelforum.com/member.php...o&userid=26954
View this thread: http://www.excelforum.com/showthread...hreadid=401729