The last method I'm going to share with you is much easier.
If this formula still makes you procrastinate - I feel you. And finally, JOIN collects those individual sentences back into their cells.To make sure all split sentences are processed, I wrap everything in ArrayFormula. When sentences are split, Google Sheets sees them as an array of cells.REPLACE - well - replaces the first lowercase letters of all sentences with their uppercase equivalents.
The part at the end of the formula - UPPER(LEFT(TRIM(SPLIT(A2,"." )),1)) - not just splits the contents but also extracts and capitalizes only the first letter (the LEFTmost one) of each sentence. Then TRIM enfolds those sentences and removes all excess spaces. If there are several sentences in a cell, SPLIT(A2,"." ) divides them into separate cells by a period. 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. Google Sheets functions to change caseįunctions are the only standard way to change case in Google Sheets. But if neither is about you, it's better to use one of the alternatives Google Sheets offers to change text case right there. 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. Select all records from one column using Ctrl+Shift+down arrow. You can select the required data range manually. But since you're in Sheets, you'll need to get your data to Docs first: When you don't find the easy way to change the case in Google Sheets, the first alternative that may come to mind is Google Docs - the service where this option exists in the menu. 
In this blog post, I share different ways to capitalize your words or turn them into lowercase, uppercase, and sentence case. Even so, the task is very much resolvable. Changing text case in Google Sheets may seem an intricate task as there is no such option in the standard menu.
0 kommentar(er)
