count no. of commas (,) in a string in a cell

  • Thread starter Thread starter hsg
  • Start date Start date
H

hsg

How can we count number of commas (,) appearing several times in a text
string in one cell. Is there any function which can be pasted in cell (B1)
to count no. of commas in cell (A1).

pl help
hsg
 
This is already answered. My query yesterday showed error in sending, so i
sent it again today, but later I found that my both querries were there
online and were asnwered as well. Thanks for 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

counting no. of times a character occurs in a cell 3
Counting the number of times a character occurs in a cell 1
How to count commas in a cell? 5
count no. of times a character occurs in a cell 2
Count the number of Commas found in cell A2 3
Count the number of occurances in a cell 2
Formula/Function for Counting Characters in a cell 4
Replace Comma with Dash 3

Back
Top