The #NUM error occurs in your Excel spreadsheet when a function or formula contains invalid numeric values. Remove #NUM errors this way!

There are different ways in Excel to remove decimals and shorten numeric values. In this article, Quantrimang.com will explain how to use the TRUNC function and point out what makes it different from ...

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Sparklines are small charts that fit into a single Microsoft Excel cell. But if you're tracking non-numeric data, they can exhibit weird behavior. Learn how to avoid problems when using sparklines.

Check the problematic cells to ensure they are blank cells. To do that, go to a cell, select it, and press the Delete key to remove the hidden character. Use the Excel function to ignore text values ...

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.