Excel Unplugged

Tag Archives: MID function

Last word in a string with an Array formula

As promised in the Pragmatism vs. Purity in Excel article from last week, this week’s article will explain the following array formula ...

Pragmatism vs. purity in Excel

One of the greatest things about Excel is that with its endless array of tools and commands it almost always offers multiple ways of achieving a certain goal. ...

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 ...