Thread: Commas in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Commas in Excel
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+(A1<"")



smcgee01 wrote:

Is there a function in excel that counts the number of items seperated by
commas in one cell?

--

Dave Peterson
Reply With QuoteReply With Quote