Perhaps Excel will create a built-in function to convert text to sentence case in the future, but until then, a formula will work. If you would like to follow along in building this formula, you can ...

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.