Formula and Functions

Convert text case in Excel 2010

If you have ever been faced with text fields that contain poor formatting or capitalisation then you will find this guide on how to convert text fields to different cases a useful read… Convert text case with Excel 2010 Data…
Read more

Excel – Fix cell with #NA Error

Learn how to fix cells that show #NA after calculation with this short guide that explains why the error occurs and how to prevent the error from displaying those ugly #NA values all over your spreadsheet… Why does the #NA…
Read more