Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more. Image: wachiwit/Adobe Stock.

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

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

MID and MIDB functions are both text functions in Microsoft Excel. MID returns a specific number of characters from a text string starting at the position you specify; based on the number of ...

Yes, you can link the contents of an Excel text box to data in a cell as follows: 1. Insert a text box. Insert a text box in Excel from the Insert tab by selecting Text, Text Box, and then use your ...

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

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.

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.

The real power behind Microsoft Excel is the ability to manipulate data that includes using functions and formulas. Because Excel’s functions and formulas can easily warrant multiple tutorials ...