Often when we use Excel, we think of its ability to operate on numbers. But, Excel is also good at operating on other data types, such as dates and text strings. When we limit our use of formulas to numbers only, we miss out on many opportunities for efficiency. In this article, I’ll talk about one of my favorite text operations, and, how it just got way better in a recent update.

http://www.excel-university.com/articles/cal-cpa/beyond-numbers/