Microsoft Excel has recently introduced three powerful new functions that leverage regular expressions (REGEX) to enhance text manipulation capabilities.

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel for the web.

For instance, Excel functions can convert text to upper and lower case, but there's no Excel function for converting text to sentence case.

Learn how 5 powerful Excel functions can enhance data analysis, financial modeling, and reporting with practical solutions.

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.

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.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.