I have previously posted about  using the Find and Replace facility to replace parts of text strings or formulae . But what if you want t...

A while back, I wrote a post explaining an approach to eliminating #DIV/0! and other errors in Excel. Although the information in the o...

This week's post is not so much learning a new Excel function, as learning a concept that you can use to enable you to import data an...

This week, I want to introduce you to the HYPERLINK function. This function allows you to add hyperlinks to your spreadsheet for both n...