Q. I read your August 2022 JofA article about changing the case of text in Excel to upper, lower, and proper, but some of my data comes in sentence form. Is there any way to convert those text strings ...

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

If you want to parse strings such as "First Last" into separate columns, you don't need to use fancy formulas. Excel has a tool that makes the job a snap.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.