I duplicated the contents in some cells (so there are sentences) and highlighted them grey so you could better understand what's happening before the case is changed (see cells A2, A6, A9 in the screenshot above): Let me show you the formula first, and then I'll explain how it works: I'm not going to lie - it's not the easiest one and it is definitely a bit of a learning curve. Sadly, there's no special function in spreadsheets as there is for the proper text case, for example.Įven so, there is a combination of other functions for Google Sheets that produce a formula that eventually capitalizes only the first letter in cells. If you want your cells to appear as sentences, it means that you want Google Sheets to make only the first letter of each cell capital without changing case of other letters. Sentence case is yet another way to present your text. If necessary, turn formulas into values as shown in this blog post. Be ready to prepare extra column(s) where you will have to enter formulas and see the result. But if neither is about you, it's better to use one of the alternatives Google Sheets offers to change the text case right there.įunctions are the only standard way to change case in Google Sheets. If you ask me, this way may do if you have a small dataset and some extra minutes to shift records back and forth. Click whatever option is necessary to change your text case, and then just copy-paste the data back to Google Sheets:.Then select it once again, go to Format > Text > Capitalization, and there you'll see 3 ways Google Docs changes cases: lowercase, UPPERCASE, Title Case:.Open the new Google Doc and press Ctrl+V to paste the copied data there.Once records are selected, copy them by pressing Ctrl+C.Or select the entire used range with Ctrl+A.
0 Comments
Leave a Reply. |