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

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

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...

In this post, we will show you how to find and replace Text Color in Excel. Text color, also known as the forecolor, is the color in which the text is displayed in Microsoft Excel.

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