Discover how Excel’s AI-powered Copilot() function transforms data analysis, automates tasks, and unlocks new productivity possibilities.

Feed it a cell reference or text string, and Excel will handle the rest. Let’s say you're migrating data from a database where names were entered in all caps and want them in a friendlier format.

Excel’s new COPILOT function uses AI to analyze, summarize, and generate content directly in the spreadsheet grid.

These are effective for structured data but may struggle with inconsistent formats. TEXTBEFORE and TEXTAFTER: These newer functions extract text based on delimiters, such as a comma, dash, or space.

REGEXREPLACE replaces text strings with new ones. These functions enhance text handling precision and provide users with flexible tools for working with data. Microsoft has also added Forms to Excel.

If you’re dealing with such data and need to adjust the capitalization, this guide is for you. The easiest way to capitalize text in Excel is by using the PROPER function.