Counting the number of characters in a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 15 May 2008 19:00 GMT

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?

Signature

Chuck W

Reply to this Message

BoniM - 15 May 2008 19:06 GMT

The LEN(cell reference) function will return the number of characters in a
cell.

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

Reply to this Message

T. Valko - 15 May 2008 19:10 GMT

For each individual cell:

=LEN(A1)

Copy down as needed.

For the total of *all* cells:

=SUMPRODUCT(LEN(A1:A10))

Signature

Biff
Microsoft Excel MVP

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

Reply to this Message