Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

You can count the number of values in a single cell in Excel and Google Sheets that are seperated by comma using this function or formula.

Whether you prefer Excel, Numbers, or Google Docs, here's what you, the savvy spreadsheet user, should know how to do.

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.