Buzz
Unlike Word, where you can use built-in tools to convert lowercase to uppercase, Excel requires the use of two functions for writing uppercase initials in a spreadsheet.
- Upper: Converts all letters to uppercase.
- Proper: Write the first letter of each word in uppercase.
Additionally, you can employ other functions (such as CONCATENATE) in conjunction with the Upper function to assist in combining character strings with uppercase initial letters in Excel.
GUIDE TO WRITING UPPERCASE INITIALS IN EXCEL
1. Convert all letters to UPPERCASE
Assume we have a data table that needs to be entirely converted to UPPERCASE as shown below. In other words, we need to transform 'nguyễn công phượng' into 'NGUYỄN CÔNG PHƯỢNG'
Step 1: Choose the UPPER function by typing '=UPPER(B5)' in cell C5
Step 2: After typing, press Enter -> the result will be displayed as shown below
Step 3: Move the mouse to the bottom right corner of cell C6 -> until the '+' sign appears -> hold and drag to the last cell where you want to convert lowercase to uppercase -> then, release the mouse, and you are done.
2. Write Initial Letters Uppercase in Excel
Similarly, we have a data table that needs to be converted to initial letters uppercase as shown in the example below. We need to transform 'nguyễn công phượng' into 'Nguyễn Công Phượng'
Follow the same steps as above, just replace the UPPER function with the PROPER function.
3. Capitalize the First Letter of Each Row in Excel
Imagine you have a data table as shown below and need to capitalize the first letter of each row only, leaving the subsequent letters in lowercase.
Step 1: In the first cell, enter the CONCATENATE function and the UPPER function as shown below:
Step 2: Next, enter the LEFT function -> click and select the cell with the word you want to capitalize the first letter.
Step 3: Enter the comma ',' to separate the arguments -> then enter the number 1, meaning one character will be capitalized -> close the parentheses ) and comma ',' to complete the first argument.
After completing the formula, you will have a function like this: =CONCATENATE(UPPER(LEFT(B5,1))
Step 4: Next, enter the RIGHT function -> then click and select the cell containing the character sequence -> enter a comma -> then enter the LEN function to select all characters in the cell.
Then, click on the cell containing the character you want to capitalize at the beginning of the line -> Next, -1 for the first character, and close the parentheses -> press Enter to complete.
Step 5: Move the mouse to the bottom right corner of cell C6 -> until the '+' sign appears -> hold and drag to the last cell -> then, release the mouse, and you have completed capitalizing the first letter of each row.
So, I've just provided you with a detailed guide on the trick of Capitalizing Initial Letters in Excel. Quite interesting and simple, isn't it! From now on, you won't spend much time editing Excel documents that you copy from elsewhere.
Furthermore, combining functions makes your calculations much more convenient and accurate, such as combining the Vlookup function with the Left function. For a clearer understanding, check out the article on how to use combine Vlookup with Left function that I've shared before! Wish you success!
