Multiple lines in cell using functions
You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to...
Links between two workbooks – dynamically using functions
I don’t believe I don’t have this here yet. This is one of my oldest tricks When we have to do links between two workbooks...
VLookup
I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to...
CONVERT function
Excel 2010 has a lot of new exciting things, one of them is the ‘Engineering’ category of functions, this was usually a plugin we have...