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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting characters 3
limit number of characters in cell 4
Limiting the number of characters in a cell 5
counting characters inside a cell 5
check first 3 characters of a cell and compare to a table 4
How can I count the number of characters on a cell? 11
how do I set a maximum characters in a specific cell 2
Can I restrict a text column to a specific number of characters? 4

Top