| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Character count
Thank you
"Gary''s Student" wrote in message ... say a1 has the full text and a2 has the character to be counted: =LEN(A1)-LEN(SUBSTITUTE(A1,A2,"")) For the data between \ use Text to Columns -- Gary''s Student - gsnu200747 "dan" wrote: Is there a formula that returns a count of a specified character? For example: Cell(A1) = I:\1stFolder\2ndFolder\3thFolder\4thFolder\5thFold er\abc.xls Answer would be 6 for "\" And also a formula that returns a folder name between 2 consecutive "\" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| character count | New Users to Excel | |||
| Character count within a cell | Setting up and Configuration of Excel | |||
| How do i set up a character count for a specified cell?? | Excel Discussion (Misc queries) | |||
| how can I count (countif) the character: * | Excel Worksheet Functions | |||
| Character Count | Excel Worksheet Functions | |||
Hybrid Mode
