Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Instances of a Specific Character
here's what I am trying to do - I am trying to split up a cell based
on it's contents. While the data is in the same order in the column and it is delimited by a space, it doesn't work to delimit it by spaces or by number of charatcers. The problem is that between the delimiters there may be 1 or 2 words - separated by a comma and the data may be of variable length. Is there a way to Count the Instances of a Specific Character - for example, is there a function to count the number of spaces in this sentence? Or the number of x's? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the times a specific character appears in a cell | Excel Worksheet Functions | |||
How do I count occurances of a specific character in a range? | Excel Worksheet Functions | |||
counting instances of specific times in fields with date and time | Excel Worksheet Functions | |||
Count Instances | Excel Discussion (Misc queries) | |||
HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL? | Excel Discussion (Misc queries) |