Read this article about changing text case in Google Sheets, to learn about LOWER (which makes text lowercase), and UPPER (which makes every letter uppercase). In this article I will focus only on the PROPER function, but there are two other "change case" formulas that you may want to learn as well. Get your FREE Google Sheets formula cheat sheet Use the ARRAYFORMULA function to apply a single formula to a columnĪfter you have completed the steps above, your formula should look like the formula below.Copy the formula down by dragging the fill handle, or.Then press enter, and now only the first letter of each word will be capitalized.Type " )" to complete/close your formula.Type " A2" (or any other cell reference) to set the reference of the cell that contains the words to be capitalized.Type " =PROPER(" into a spreadsheet cell, as the beginning of your formula.To capitalize the first letter of each word in Google Sheets, do the following: This is also sometimes referred to as "Title Case". The PROPER function will automatically change the case of text so that only the first letter of each word is capitalized. If you ever need to quickly capitalize the first letter of each word in a Google spreadsheet, there is a very simple function that can be used to accomplish this.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |