Tired of capitalising each word one by one in Excel? Or maybe you realised you capitalised the wrong letters?
With the Excel PROPER function, capitalise the first letter of each word automatically!
Are you ready to learn how to use this time-saving-formula?
Capitalise the first letter of each word in Excel
Writing the first letter of each word in upper case can create visual interest and bring clarity to your data. Instead of doing it manually, you can use an Excel function called PROPER.
What is the PROPER function
The PROPER function capitalises the first letter of each word in a cell and keeps other letters in lower case. Its formula is =PROPER(text) with text being a cell or a range of cells containing a text. If you want to use the formula directly with a text enclose it with quotation marks: =PROPER(“your text“)
For example, =PROPER(“eXcel”) will become “Excel” in MS Excel.
How to capitalise words in Excel
Capitalise the first letter of each word in Excel by entering =PROPER(text); check the example below to get familiar with automatic capitalisation.
In this example, let capitalise the first letter of each word in cells A29 to A32.
Enter =PROPER(A29:A32) and press Enter.
Now, all words in these cells start with a capital letter!
Now, you know how to write the first letter of each word as capital letter in Microsoft Excel.
Become an Excel Master: join our Online Training Course now!