Tame your computer - FlashFill your case

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).

Roem tip time logo

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 620you can use its keyboard shortcut.

Here’s how:

  1. Open FlashFill.zip to understand this example.
  2. Click in cell B2.
  3. Type ANNE BROWN or anne brown.
  4. Press ENTER.
  5. 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 :)

Related tips

Upcoming courses

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

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk


Looking for something specific?