Convert All Rows in a particular column in CAPS

[Darren_Murphy]

hmm, I may have been a bit hasty there. When I responded I was thinking of this

Filter visibility by Character Count!

I think I got something here. Not the cleanest solution, but not too bad either. Just takes a little math. Here you can see that column 11 has two rows with text in it. New Column L has a template with the value of 1 in it. New Column J is a template that replaces every letter (and space if you choose) with the number ‘1’. You shouldn’t need to replace any numbers as they are already numbers, but you will probably have to include every letter of the alphabet along with any symbols you would…

But, maybe not…
This is yet another example of something that would be trivial with some string manipulation functions.
And of course it’s also trivial with a spreadsheet function.
But in the GDE with the tools we currently have…
I’ll have a play…