Excel Unplugged

Monthly Archives: July 2014

Convert Text to Numbers in Excel

A task that comes about every so often in Excel and can be quite tricky. Now our ultimate goal is to get a number out of something like (text 1 text) or even ...

Custom Cell Format You Must Know in Excel

Custom cell formats are a very important steppingstone to eternal happiness in Excel. And among all Custom Formats, one takes precedence for both, its usability and ...

Rounding numbers to a specific multiple in Excel

Excel can be very tricky about rounding numbers. Almost half of Excel users still believe that if they format a cell to round to two decimals, that what they see is ...

Fill All Blank Cells in an Excel Range With a Desired Value

How to fill blank cells in Excel with a desired value? In this tutorial we’ll be selecting all the blank cells and fill them in. Part one will be selecting all ...

Why Excel thinks “Time is on my side” by the Stones is a joke on him…

Excel has quite a few funny perks. Once you get over the 15 digit limit in Excel and the fact it does not calculate exactly as it should, you will sooner or later ...