| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting a certain character
I have a cell with this the following data in it:
0800_______________________ 00000001 00005212 00012312 I would like to count the number of "_" in the cell. I have tried the countif(A1,"*_*") but I only get a return of 1 count. I would like to know how many of the "_" there are in the cell. Thanks for the help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting a certain character
Try,
=LEN(A1)-LEN(SUBSTITUTE(A1,"_","")) Mike "James" wrote: I have a cell with this the following data in it: 0800_______________________ 00000001 00005212 00012312 I would like to count the number of "_" in the cell. I have tried the countif(A1,"*_*") but I only get a return of 1 count. I would like to know how many of the "_" there are in the cell. Thanks for the help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting a certain character
It works and I was able to go through my 30,000 row spreadsheet and easily
see that there are difference with all the "_". It helped a great deal. "Mike H" wrote: Try, =LEN(A1)-LEN(SUBSTITUTE(A1,"_","")) Mike "James" wrote: I have a cell with this the following data in it: 0800_______________________ 00000001 00005212 00012312 I would like to count the number of "_" in the cell. I have tried the countif(A1,"*_*") but I only get a return of 1 count. I would like to know how many of the "_" there are in the cell. Thanks for the help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting a certain character
Your welcome
"James" wrote: It works and I was able to go through my 30,000 row spreadsheet and easily see that there are difference with all the "_". It helped a great deal. "Mike H" wrote: Try, =LEN(A1)-LEN(SUBSTITUTE(A1,"_","")) Mike "James" wrote: I have a cell with this the following data in it: 0800_______________________ 00000001 00005212 00012312 I would like to count the number of "_" in the cell. I have tried the countif(A1,"*_*") but I only get a return of 1 count. I would like to know how many of the "_" there are in the cell. Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Specific Character(s) In A Range? | Excel Discussion (Misc queries) | |||
| simple, counting the last character in text | Excel Worksheet Functions | |||
| Counting Cells w/ a certain character in them? | Excel Discussion (Misc queries) | |||
| Finding/counting a given character within a cell | Excel Worksheet Functions | |||
| COUNTIF not counting properly!! Character limit? | Excel Worksheet Functions | |||
Linear Mode
