Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

How to Find & Replace Text Parts in MS Excel. Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. Luckily, Microsoft included a couple of useful ...

In this month’s column, find out how to change text strings to sentence case in Excel.

Q. I use a spreadsheet that includes a list of machine parts identified by both words and numbers—for example, Part 2312. Since the cells contain both text and numbers, how can I sort them in ...

How to Delete a Row if Text Equals VBA in Excel. Microsoft Excel 2010 comes with the latest version of Visual Basic for Applications, or VBA, which is a programming language designed to interface ...