| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I perfom a character count in a single cell in Excel?
If you count spaces as a character, you can use directly the function LEN.
If you don't want the spaces to count, use something like: =LEN(SUBSTITUTE(A1," ","")) Hope this helps, Miguel. "RonNette72791" wrote: I need to peform a character count for certain cells in Excel. I found a formula for counting words within a cell but not the number of specific characters. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, how to count every 4th cell in column to see if occupied? | Excel Worksheet Functions | |||
| How can I enter multiple paragraphs in a single Excel cell? | Excel Discussion (Misc queries) | |||
| Can I run Excel LookUp on a single cell through multiple sheets | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| how can I split a single cell diagonally in Excel 2000 | Excel Discussion (Misc queries) | |||
Threaded Mode
