how to count charachters in excel sheet

[abhijit786]

I have an excel sheet , I want to count characters in the sheet ,number or strings whatever

THANKS in advance
Regards

[canapone]

Hi,

a quick system is to copy the Excel contents into a Word file and use Count tool

Regards

http://office.microsoft.com/en-us/wo...003082490.aspx

[vlady]

if you mean count every letters in the range

maybe???

=SUMPRODUCT(LEN(your range to count))

[abhijit786]

if you mean count every letters in the range

maybe???

=SUMPRODUCT(LEN(your range to count))

thanks vlady

it is working