Counting the number of characters in a cell

C

ChuckW

Hi,

I have a column called Part Number that has alphnumberic values that are
anywhere from 6-12 characters. I need to calculate the number of characters
in each cell. Is there a way to do this?
 
T

T. Valko

For each individual cell:

=LEN(A1)

Copy down as needed.

For the total of *all* cells:

=SUMPRODUCT(LEN(A1:A10))
 
Top