View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
orchid11652 orchid11652 is offline
external usenet poster
 
Posts: 8
Default I need to count occurr. of the character "," in a single cell

i need a formula to count the occurence of the comma character (",") in a
single cell. That's the easiest way I can think of to count dates that are
exported into a single excel file. I know I could use the text to column
function and use "," as the delimiter and then count the cells, but there are
a lot of dates and I might run out of columns.