Thread: count no. of commas (,) in a string in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default count no. of commas (,) in a string in a cell
Try this formula...

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

--
Rick (MVP - Excel)


"hsg" wrote in message
...
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

Reply With QuoteReply With Quote