How to Capitalize First Letters in Excel With PROPER Function

Описание: How to Capitalize First Letters in Excel With PROPER Function


Want to make the first letter of each word capital in Excel? This video will show you exactly how to do it using the PROPER function. It’s a quick and simple way to clean up your text and make your data look neat and professional in Microsoft Excel.


When working with text in Excel, you might notice that some words are in lowercase or uppercase and look inconsistent. Instead of fixing each one manually, you can use a built-in function that automatically capitalizes the first letter of every word for you.


To capitalize first letters in Excel with the PROPER function, start by selecting the first cell where you want the result to appear. Then type =PROPER( and select the cell that contains the text. Close the bracket and press Enter. To apply it to the other cells, just double-click the bottom right corner of the cell and you’re done.


#excel #exceltutorial #microsoft365