If you work with a lot of text-based data in your Excel spreadsheets, formatting it can easily become a tedious chore. Unlike Microsoft Word, Excel does not include a Change Case tool for editing text with special upper, lower or other types of capitalizations.
One of those times you may need to capitalize names in Excel. So, how do you do it? No, that’s not a joke. Excel has a function called “Proper” that capitalizes the first letter of each word in a string. This is the easiest function to use to capitalize names in Excel (there are other methods, but they’re not that pretty).
How to capitalize every letter in Excel?
With the PROPER function, every letter will be converted to lowercase except for the first letter of each word. You can use functions to capitalize in Excel and you can also use some VBA code to do the same.
Type formula =UPPER(A1) into the Formula Bar, then press the Enter key. Drag the Fill Handle down to the range which you need to capitalize all letters. Now all letters in specified cells are all capitalized.
After typing the code, switch back to the worksheet and select the area or range of cells you wish to capitalize. When you are done with the selection, switch back to the VBA code and press the F5 key. Every selected cell should be capitalized successfully. You can assign your macro to a button control.
This begs the question “How to exclude capital letters from text in Excel?”
The lower () function helps to exclude capital letters from text. The proper () function makes the first letter of each word capitalized and leaves the other letters lowercase (Proper Case). All three of these options work on the same principle, so I’ll show you how to use one of them. Let’s take the Excel uppercase function as an example.
How do I change the capitalization of a column in Excel?
Unlike Microsoft Word, Excel does not include a Change Case tool for editing text with particular upper, lower, or other types of capitalizations. So, what’s the solution to a problem like this? You could copy the column into Microsoft Word, use the Change case tools, then copy and paste it into Excel again.
After inserting the column, activate the first blank cell next to the column containing text. Proceed to enter the formula to change the case; specifically, for proper, this would be =PROPER (A3). If you want to use a different type of capitalization, =UPPER would capitalize all letters, while =LOWER would convert to all lowercase letters.
How do you capitalize proper nouns in a cell?
If you have cells containing proper nouns, like names or titles, you can use the PROPER function to make sure everything is capitalized correctly. The PROPER function works in Google Sheets too.