📞 01223 214177 ✉️ karen@roem.co.uk
As you probably know, Excel has no Change Case button like Word has. (And no, SHIFT + F3 doesn't work either.) Instead, you might be using Excel's UPPER and LOWER Functions to change text in a cell to UPPERCASE or lowercase.
But if you are using version 2013 or later you can use the Flash Fill functionality from the Auto Fill Options button that pops up when you've used the Auto Fill feature. Or - as described in tip 620 - you can use its keyboard shortcut.
Here's how:
Excel will recognise the "pattern" you specified in step 3 and converts all text to uppercase or lowercase letters. No need to work with "helper columns" to store the newly formatted text. As a recent webinar attendee wrote "Like watching Professor McGonagall transfigure into a cat"
Related tips
.
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.