Skip to content

Instantly share code, notes, and snippets.

@tristar500

tristar500/gist:decc8f30d1521aa6f827c61efebefbb3

Created May 31, 2017 15:44
Show Gist options
  • Save tristar500/decc8f30d1521aa6f827c61efebefbb3 to your computer and use it in GitHub Desktop.
Save tristar500/decc8f30d1521aa6f827c61efebefbb3 to your computer and use it in GitHub Desktop.
Download ZIP
Excel - count items in a comma separated list in a worksheet cell
Raw
gistfile1.txt
=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment