| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Counting number of time a character appears in a string
On Thu, 20 Oct 2005 14:25:02 -0700, Henrik
wrote: Does anyone know a way to automatically count how many times a certain character counts in a text string? To count the number of appearances of a character in a text string: =LEN(A1)-LEN(SUBSTITUTE(A1,char_to_count,"")) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
| Insert a Seperator into a number string. | Excel Discussion (Misc queries) | |||
| last number array from string | Excel Worksheet Functions | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
Threaded Mode
