Use the Flash Fill function in Excel to change text

Manipulating data in Microsoft® Excel® may involve changing the text case from lower to upper case. Luckily, there is an easier way of doing this without using complicated formulas.

A new feature in Excel 2013 and 2016 is the Flash Fill option. This can be used to change the case of consistent text. It can also be used to split and join (concatenate) consistent text.

In this week’s tip, we are going demonstrate how to use the Flash Fill option to convert names from lower to upper case.

Note: Your are welcome to download the workbook to practice

Applies To: Microsoft® Excel® 2013 and 2016

  1. Select cell B2 and enter “JANUARY”.

flash-fill1

2. Select the Data tab and then Flash Fill.

flash-fill-2

3. The months will all be converted to upper case.

flash-fill-3

The months have been quickly and easily converted to upper case without the use of complex formulas.