count no. of times a character occurs in a cell

H

hsg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Delete all data after a symbol in a field 0
Cumulative formula for word table 0
counting no. of times a character occurs in a cell 3
count no. of commas (,) in a string in a cell 3
Managing multiple jobs in a fabrication shop 0
Counting the number of times a character occurs in a cell 1
Function in Excel to count and list number of entries of text valuesin a row. 2

Top