Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER () and TEXTBEFORE () in this tutorial.

Over years of working with Excel, I have stumbled upon a collection of functions that have transformed my workflow. These aren't your basic SUM and AVERAGE formulas; these are the hidden gems that can ...

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

There's no doubt that the rise in automated tools in Microsoft Excel is reducing the need for people using the program to have high-level math skills. That said, having good math skills will ...

The MID and MIDB functions in Excel return a specific number of characters from a text string starting at the position you specify.

In Microsoft Excel, the PROPER function is a Text function, and its purpose is to capitalize the first letter in each word of a text value that will remain in lowercase or convert to lowercase.

You don’t have to struggle or scratch your head when it comes to using Microsoft Excel. This guide for beginners will get you off to a solid start with Excel.

Unlike Microsoft Word, Excel 2007 does not include a Change Case feature for quickly converting capitalization styles. However, Excel does have functions that convert text to lowercase, uppercase ...

Microsoft Excel is a spreadsheet software with legions of fans. Learning Excel and its functions and formulas can be tricky, but here are the basics.