| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurences of a letter in a cell | Excel Worksheet Functions | |||
| Count Characters with space in a cell | Excel Discussion (Misc queries) | |||
| Excel 2002: How to eliminate space within a cell and count items? | Excel Discussion (Misc queries) | |||
| How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
| count a number range and a letter in a cell | Excel Worksheet Functions | |||
Linear Mode
