Letter and space count in cell
 

Excel 2007
In column A I have part numbers. It consists of letters, numbers, and spaces.
Is there a way to get a count of characters used for each cell (including
spaces)
Example
Column A Column B
HP32 645z 9
R2 V1 64 8

How do I get column B to show those numbers... counting, letters, numbers,
and spaces.

Any help is GREATLY appreciated.

Letter and space count in cell
 

Use
=LEN(A1)
in B1 and copy down col A
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jerid B" wrote:

Excel 2007
In column A I have part numbers. It consists of letters, numbers, and spaces.
Is there a way to get a count of characters used for each cell (including
spaces)
Example
Column A Column B
HP32 645z 9
R2 V1 64 8

How do I get column B to show those numbers... counting, letters, numbers,
and spaces.

Any help is GREATLY appreciated.