Are you tired of manually changing the case of text in your Google Sheets? Well, fret not! In this article, I will show you how to apply bulk change case in Google Sheets using the powerful QUERY function. Trust me, it’s a game-changer!
Bulk Change Case in Google Sheets Using Query
Let’s dive right into it. The first thing you need is a sample data set. Take a look at the table below:
Now, suppose you want to capitalize the text in columns A and B at the same time. Here’s where the magic happens – the QUERY formula. Use the following formula to achieve the desired result:
=QUERY(A1:D17,"SELECT UPPER(A), UPPER(B), C, D")
In this formula, A1:D17 represents the range of your data. By using the UPPER function, you can capitalize the text in columns A and B while preserving the values in columns C and D. Simple, right?
To replace the existing table with the capitalized one, follow these steps:
- Go to the cell that contains the formula. In this case, it’s cell F1.
- Copy the formula using the keyboard shortcut Ctrl + C.
- Navigate to cell A1 and paste the formula using the Alt+E+S+V shortcut or by right-clicking on the cell and selecting Paste Special > Values.
Voila! You now have a table with the capitalized text. Feel free to delete the cell that contained the formula.
Limitation
It’s important to note that the QUERY formula currently supports only two case functions: UPPER and LOWER. Unfortunately, the PROPER case function is not available in QUERY at this time. Don’t worry, though – the UPPER and LOWER functions should cover most of your needs.
Conclusion
The QUERY function in Google Sheets is a powerful tool that can revolutionize the way you handle data. Investing some time to master it will undoubtedly pay off in the long run.
If you’re hungry for more knowledge about the QUERY function, you’re in luck! We have plenty of tutorials, ranging from basic to advanced, right here on Crawlan.com. Whether you want to format dates, filter numbers, convert month numbers to names, or explore the function with examples, we’ve got you covered!
So what are you waiting for? Head over to Crawlan.com and unlock the full potential of the QUERY function in Google Sheets. Your data will thank you later!
