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.

How to Capitalize Text in Excel Need to make a bold statement by converting everything to upper case? Excel’s UPPER function has your back.

With cell B2 selected, I can now use the fill handle in the bottom-right corner of the cell to duplicate this relative formula to the remaining rows of details.