| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL?
How can a frequency of a specific character be counted with in a cell. Ex -"
#4 Bluebirds, #6 Aquatic" is in cell B2 - how do I count the number of "#" that appear in cell B2? |
|
#2
|
|||
|
|||
|
=LEN(B2)-LEN(SUBSTITUTE(B2,"#",""))
HTH Jason Atlanta, GA -----Original Message----- How can a frequency of a specific character be counted with in a cell. Ex -" #4 Bluebirds, #6 Aquatic" is in cell B2 - how do I count the number of "#" that appear in cell B2? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i count character in cell? | Excel Discussion (Misc queries) | |||
| How to count occcurence of specific text block in a column | Excel Discussion (Misc queries) | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
| Count items between specific hours on a matching date | Excel Worksheet Functions | |||
| How do I count my data that are between specific values? | Excel Worksheet Functions | |||
Linear Mode
