| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count no. of times a character occurs in a cell
Is there any function which can tell how many characters (commas) are there
in a cell? example: if I enter [12,13,15,16] in a cell, I would like to know how many entries have been made in that cell, each separated by a comma. I figure from the data that no. of entries shall be no. of commas plus ONE, i.e. in above case three commas mean 4 separate numbers. Can this be done with a simple function? because if A1 has above entry, B1 should tell how many numbers have been entered in A1. Similer entries will exist in column A (i.e. A2, A3 etc...) and then whenever such an entry is made, B2, B3 etc... should automatically tell how many entries are there in these cells. Pl help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count no. of times a character occurs in a cell
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
-- Gary''s Student - gsnu200840 "hsg" wrote: Is there any function which can tell how many characters (commas) are there in a cell? example: if I enter [12,13,15,16] in a cell, I would like to know how many entries have been made in that cell, each separated by a comma. I figure from the data that no. of entries shall be no. of commas plus ONE, i.e. in above case three commas mean 4 separate numbers. Can this be done with a simple function? because if A1 has above entry, B1 should tell how many numbers have been entered in A1. Similer entries will exist in column A (i.e. A2, A3 etc...) and then whenever such an entry is made, B2, B3 etc... should automatically tell how many entries are there in these cells. Pl help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count commas in a cell
works exactly,
thank you Gary's student and Ashish hsg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of times a text occurs | New Users to Excel | |||
| Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
| I would like to count the # of times a value occurs in Col B base | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
Hybrid Mode
