To capitalize the first letter of a text string in Excel, you can use a formula that combines multiple functions. We show you how to do it.

CONCATENATE, an Excel function used to join various text strings into one, is available in Excel 2007 and later versions. The syntax for the CONCATENATE function is CONCATENATE (text1, [text2], …), ...

Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...

How to Use Excel to Parse Text. Computer programmers often use parsing programs to convert text into formats that other applications can use. Parsers split items in a text string into separate fields.

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

You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.