The easiest way to calculate the number of characters in the column
would be to use an adjacent cell to calculate the length of the string
in each cell of your column, and then sum the results, as follows
A _____ B
* _____ =LEN(A2) {result would be 1}
*? _____ =LEN(A3) {result would be 2}
=SUM(B1:B100)
--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread:
http://www.excelforum.com/showthread...hreadid=525945