ExcelBanter - Counting the number of characters in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting the number of characters in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/187623-counting-number-characters-cell.html)

ChuckW

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

--
Chuck W

BoniM

Counting the number of characters in a cell

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

"ChuckW" wrote:

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?

--
Chuck W

T. Valko

Counting the number of characters in a cell

For each individual cell:

=LEN(A1)

Copy down as needed.

For the total of *all* cells:

=SUMPRODUCT(LEN(A1:A10))

--
Biff
Microsoft Excel MVP

"ChuckW" wrote in message
...
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?

--
Chuck W

All times are GMT +1. The time now is 08:46 PM.