In her regular series for Cambridge Network members - now in its 15th year - software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she describes how to change case without using Formulas and Functions (Microsoft Excel 2013 onwards).
Tame your computer - FlashFill your case
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.
- Open FlashFill.zip to understand this example.
- Click in cell B2.
- Type ANNE BROWN or anne brown.
- Press ENTER.
- Press CTRL + E.
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 :) “
- Split first name and last name into separate cells or combine first and last name in one cell
- Quickly increase a list of numbers by one
- Toggle between UPPER CASE, lower case and Sentence Case in Word
Given the new national lockdown restrictions, all our training sessions will be in a virtual setting from 5 November until 2 December. Our current course and webinar schedule can be found online.
2 November 2020