To count the characters in a single cell, the text function in Excel, LEN comes in handy. While the syntax is LEN (cell), the exact formula to find out the number of characters in a single cell is ...

Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.