Let's start this off with a formula!

Here’s a quick one to change the case of a column of text in a cell.

=Upper(your text) will change lower and mixed case entries to upper case. Talk about options, try Lower(your text) to change those pesky upper-case entries to lower case. And just in case you thought we were done, you can even change entries to sentence case with =Proper(your text).