REGEXEXTRACT: Find Specific Pieces of Text This function returns parts of text in a cell according to a specified pattern. For example, you might want to separate numbers and text.

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.