midwestger.blogg.se - Excel shortcut keys capital letters

The logic: Capitalize all letters in cell A1, by using the UPPER function The task: Capitalize every letter in an entire sentence Instead of changing each letter to uppercase manually, you can use the UPPER function to automatically change every letter of the sentence to uppercase. Let's say that you had previously written a message for others to see in a spreadsheet, and that you want to change it to all capital letters so that it will stand out and so that others will know that it is important. Let's begin with a simple example, where we will capitalize the text that is entered into a single spreadsheet cell in Google Sheets. Capitalize all letters in a Google spreadsheet Then later I will also show you how to capitalize an entire column with the UPPER function. In the examples below, I will show you several ways to use the UPPER function in Google Sheets, to capitalize a string of text, or in other words how to capitalize the text that is contained in a cell.

Google Sheets description for the UPPER function:įormula summary: “Converts a specified string to uppercase” The UPPER function is a very simple function that only requires you to assign a cell reference to specify the location of the text that you want to capitalize. The Google Sheets UPPER function will automatically capitalize every single letter in the text that it refers to. "How to change text case in Google Sheets with UPPER/ LOWER/ PROPER" The Google Sheets UPPER function: But in this article we will stick to using UPPER. To learn more about all three of these case changing formulas, check out the article below. Where the UPPER function will capitalize every letter, the LOWER function will make every letter lowercase, and the PROPER function will capitalize the first letter of every word. This article focuses specifically on the UPPER function, which is one of the three "change case" formulas in Google Sheets. Get your FREE Google Sheets formula cheat sheet

(Optional) Click and drag the fill handle to copy the formula down, or use ARRAYFORMULA to extend your formulaĪfter following the instructions above, your formula should look like the formula shown below.Ĭlick here to get your Google Sheets cheat sheet UPPER formula examples:.

Then press enter, and your text will now be capitalized.

Type " )" to include an ending parenthesis with your function.

Type " A2" (or any cell reference that you want) to refer to the cell that contains the text that you want to capitalize.

Type " =UPPER(" into a spreadsheet cell, to begin your function.

To capitalize all letters in Google Sheets, do the following: The UPPER function is very easy to use, since all you need to do to use it, is to designate the cell that contains the text which you would like to capitalize. If you want to quickly capitalize all letters in a cell, or range of cells in Google Sheets, this can be done by using the UPPER function.