View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CaptainQuattro
 
Posts: n/a
Default how can i make excel sum up the number of letters i have in a row?


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