| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of characters in a cell | Excel Worksheet Functions | |||
| Counting number of characters? | New Users to Excel | |||
| Counting the number of specified text characters within a cell | Excel Worksheet Functions | |||
| counting characters in a cell | Excel Discussion (Misc queries) | |||
| Counting Characters in a Cell | Excel Worksheet Functions | |||
Linear Mode
