View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default 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.