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

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.

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

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

Q: I receive client files with text on multiple lines that are all part of the same sentence. How can I easily incorporate all the text in one cell? A: You can combine text that is separated into ...

Often known as the universal data munging tool, Excel is trying out new options for processing messy text as well as entering it more quickly and accurately in the first place.

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.