| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count specific characters in a cell
Is there a way to count the number of times a specific character occurs in a
specific cell? For example, if cell A1 has "ABC123ABC" and I wanted to count the number of occurances that "A" showed up, and wanted the out put to be in B1. In this example the desired result would equal "2". -- Thank you, John Gregory |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I set a maximum characters in a specific cell | Excel Discussion (Misc queries) | |||
| how do I set a maximum characters in a specific cell | Excel Discussion (Misc queries) | |||
| Counting specific characters in a cell | Excel Discussion (Misc queries) | |||
| How to remove characters in a cell that precede a specific hyphen | Excel Discussion (Misc queries) | |||
| how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
Threaded Mode
