Surely you all know that with separate names or proper nouns when entering content in Word or creating data tables in Excel, you must capitalize the first letter. Normally, when typing, the user had to type and capitalize already. You can use the Shift key or press Caps Lock to capitalize. But if you have large files, you must edit a lot but using these 2 keys will be very time consuming. Then you can convert uppercase to lowercase with Unikey in Excel or preferably using the Proper function to Capitalize the first letter in Excel.
Capitalize first letter in Excel
Instructions for capitalizing the first letter in Excel 2019
In this article, we will show you some ways to capitalize the first letter in Excel 2019, please follow along.
1. How to capitalize the first letter of Excel when entering data
For the beginner spreadsheet in importing data, you should pay attention to the proper name, proper nouns and perform capitalization of the first letter in Excel always, avoid later detection of many mistakes, then have to correct it. very time consuming.
With typing and capitalization when entering data, the writing will be very simple only. You use the Shift key and type the letter to capitalize, then release the Shift key, then you will enter the next letters that are lowercase followed.
Another way to capitalize the first letter is that you will use it Caps Lock key. To use this key is quite simple, you will press the Caps Lock key first, followed by the letter you want to capitalize. If you only capitalize the first case, you will need to turn off Caps Lock after you finish writing. You only get one more time on the Caps Lock key to turn off. If you leave Caps Lock on after the first press, you’ll default to capitalize all letters.
2. How to capitalize the first letter of Excel with a function
Want to capitalize the first letter in Excel in addition to the manual above, you can use the PROPER function to perform the conversion of existing text into a new paragraph, and the entire first letter will be capitalized.
The formula using the PROPER function will be:
= PROPER (the text should be capitalized in the first letter)
You can replace the text to capitalize with cells in Excel. If you use paragraph text -> then you need quotes.
In the image below with the words in this table when you enter the function will have quotes “free download”.
If you replace text with a cell position, you don’t have to enter quotation marks because Excel automatically understands which cell the text is capitalizing.
As a result, after you press Enter, the first letters will be capitalized. You drag down the mouse to copy the results of the first cell down to the remaining cells is finished.
In addition to you use functions PROPER Capitalization in Excel, you can also use UPPER function to capitalize the whole letter.
How to use functions UPPER Pretty simple. This function is equivalent to clicking Caps Lock to capitalize all letters in Excel.
The formula and syntax of this function is:
= UPPER (text content wants to capitalize all letters)
Similar to the function PROPER then enter the function UPPER If you enter text, you must have quotation marks, or you can replace the text with the cell position.
Results after you Enter will be like in the picture below. If you have multiple cells that need to be capitalized all the way down, you just need to drag the results in the first cell down to the other cells to copy, apply the UPPER formula.
Above is the introduction and guide you Capitalize the first letter in Excel 2019 Simply use the keyboard to use the Shift and Caps Lock keys to capitalize the first letter. In case of editing tables with many text contents, you should use the first letter capitalization function PROPER capitalizing the first letter of a spreadsheet saves time and effort instead of having to type it in manually, taking a long time.