by Fiona Hannon | Oct 17, 2013 | Blog, Excel Formulas, Excel Formulas, Excel Tips, Uncategorized
Let’s take a look at the following really useful functions that will help us every day in Excel. Functions that help with CASE This set of 3 functions are very handy to use when text has been imported into Excel and it has not arrived in the correct case. Maybe... by Fiona Hannon | Oct 17, 2013 | Blog, Excel Formulas, Excel Formulas, Excel Tips, Uncategorized
Let’s look at a scenario where data is given to you in .CSV format or already has been imported into Excel for you. It may be the case that you have a list of ID numbers, when they are pasted or imported into Excel, the leading Zero which was there in the...