79% OFF online library of tutorials for mastering Google Sheets
This tutorial is not available for free users. Please purchase a subscription to view this tutorial.
Hey there stranger!
Please sign-up or sign-in to watch this tutorial.
Benoit Asks: How to Convert Case
About this Tutorial
Conditional formatting move my face over here. The formatting styles you can choose from are just fill color. a text color strike through underlying italic or bold or all. And then when you have, you have sort of these three options here and there's nothing else you can choose your custom formula that you chose or these what is interesting though is even in color scale, you can't do that as well.
Unfortunately you can. Do that in conditional, but here's a couple ways you sort of, the answer to your second question again is not really great, but it is what I do, and then I'll give you a weird way to do that in font. So you have a list of say names and you want to lowercase them, right? You would do lower and then you have this other column, right?
Of all of this, these formulas, right? You. The only thing you can really do differently is wrap this in an array formula. So you go array Formula, formula and then put C to C there. And now you can do the entire column all in one formula. And then, By hand command C, which is copy, and then go over this and I do shift command V for paste values, so then I can get rid of this.
So this is really only remembering this sort of double formula array formula lower and then DeLeT that. And so now you have it accomplished. Programmatically you can do this with script. . There is in scripts, actually, I will show you in a second, but the only way that I can show you right now very quickly is to show that you can create a different formula.
So you can say like e equals you. C1 we'll come back to this in a second. It's gonna give us an error right now. But again, you can go error a formula, you can do upper. C one or C to C, and now you can command C and shift command V for copy and paste value. So doesn't take so much time to do that. Same with doing this proper, and we get it back to its proper place.
So then command C, shift command V, and now I have my choice of any of these I can.
I can copy and paste into here. We'll get back to that. We'll get back to this error over here in a second so we can delete that. And now we have proper right, so a little quicker than say going proper E one and then, you know, copy and pasting down here. , but we'll see. Maybe that helps you out.
But here, how do we get this, which is even a faster sort of upper, and you can almost do anything you want. You go to tools. Let's go to script editor. I've done this a couple times already, so you might see some scripts here already written. So I wrote this script, which is just a function U and E is here for.
you can do macros and record them and edit them, but it's gonna be, it's pretty deep conversation. I don't know the exact macro you'll want to use because I don't know how often you're using this. And, and if you are saying if any of these are edited, do them again. So I won't go too deep into this, but really all you're gonna do is say tools, macro.
You're gonna record a macro and then there's ways you can edit that macro in order to continually do that. You know, maybe every night go through and do exactly what you need to do. But I can't really show you macro. Cause I don't know exactly. If you're doing the entire column, if you're saying if a bunch of ifs, like if this is this way or this is, this is this way, with your conditional formatting, you're usually.
Based on some condition and what that condition is it wasn't clear. So happy to try to answer your question deeper if you have some specific situations that you want to use this. So, so far here I said you can use array formula to sort of get a little faster. And probably some.
Scripting. The other way is if you want to, this is weird. You can use fonts that are only an uppercase, sometimes this visually is appealing and also prevents people from. entering a lowercase. For some reason, I, and I only, I can only come across uppercase. You, you can find maybe some other fonts that are only lowercase.
But these two, this one is Allegra alleg, sorry, alleg Graya font. It is a small cap font, so what happens is the upper. They're all uppercase, but the lowercase are smaller upper cases, small caps, and six caps. Font as well is an all uppercase but also small caps where you, you can see just a very tiny difference between the uppercase and lowercase and.
That's it. So unfortunately, conditional formatting doesn't work for what you need. The array formula and possibly a script is gonna increase your speed here, so you can do as you c1, let's see. Right, so that's quicker than typing upper upper c2, right? So equals U c3. . So you can save a few keystrokes there if you create a script.
And you should be able to do all of, all of the different types of ones. And then, yeah, the array formula, just to be able to type one formula here for the entire column is pretty much the fastest that I, I know right now that you can do. And then, yeah, you can also try to use some all caps fonts. Hopefully that helped you come up with some creative ways.
Your problem, and if you want to describe your problem in a little bit more detail, I'm more than happy to try again at one of these solutions, probably better than the other's. Bite.
Sheet Stories / Video Notes + ADDED: Email Notifications
Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet
Getting Started Coding in Apps Script
Seek Errors When Coding Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
ChatGPT Clone in Google Sheets Part 2
ChatGPT Clone in Google Sheets Part 1
Quickstart Tutorial OpenAI API in Google Sheets
Embed a Number in a Website from a Google Sheet
Create Navigation Like A Book or Presentation
Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?
Embed a Headline in a Website from Google Sheets
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Hold a Giveaway Raffle in a Google Sheet
Create a new Spreadsheet from just a Name in a Sheet.
Email Yourself a Cell from a Google Sheet, Every Day
OpenSea Data Inside Sheets
Shwitter | Twitter in a Google Sheet
Create an Email Campaign Stats Calculator
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value
Highlight Row as You Move Your Cell Selection
Create a Timer with Apps Script
LinkTree in a Google Sheet
Password Protecting Data In a Google Sheet
Automatic Weekly Backup of Google Sheets
Create a CPM Custom Function (Create Better Calculators!)
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script
What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
Sync Two Tabs Without ImportRange()
Password Protecting Data In a Google Sheet Part 2 The Basics
Benoit Asks: How to Convert Case
Learn to Code in Google Sheets, For Programmers
Add a Checkbox to Turn on Dark Mode
Write Your First Script
Find Keywords in Any Column, And create a quick search dropdown to find them.
Basic CRM - Add a Powerful Script To Move Row Based on Status
How To Improve: 1,000 Business ideas: Business Idea Generator
Let's Make a Bookmarklet!
Troubleshooting Bitly in a Google Sheet Script
Unique Features - Design a Better Dashboard Part 2
How To Set Up Stripe Webhook to Google Sheets with Google Script
How to Edit a Macro
Sheet Stories / Video Notes + Clear 24 Hour Old Videos
Add A Timestamp to Task Lists (without Now Formula)
Make your Custom Functions Like Native Functions | Custom Function Autocomplete
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop
New Syntax for WhatChanged Formula in Google Script
How to Record Macros
2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)
Deep Inside Dark Habits Google Script
How to Trigger Macros Daily
5 Ways to Create Coupon Codes | Create UUIDs
Create a Radio Button From Checkboxes Using Google Script