Let's start this off with a formula!
- Magic Rabbit Hat
- Jul 12, 2018
- 1 min read
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).
Commentaires