How to change case in Excel

Excel users frequently want to change case in one or more columns. For example to turn:

Excel split first last

Into:

Excel split column

You can do this in Excel using the LOWER(), UPPER() and PROPER() Excel functions. But it is fairly onerous and error prone, especially if you have a lot of rows and columns or lots of worksheets to update. You also lose the data that was there before.

However it is very easy to change case in Easy Data Transform:

  1. Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully functional free trial and you don’t have to give us your email or sign up to anything.
  2. Start Easy Data Transform.
  3. Drag the Excel spreadsheet whose columns you wish to change case onto Easy Data Transform. If there is more than one worksheet you will be asked to choose which ones to input - choose one with case you need to change. A pink input item will be added.
  4. Ensuring the pink input item is selected, click the Case button in the Left pane.

Excel title case

A blue transform item is added and selected.

Excel change case

In the Right pane select the column(s) you wish to change and the desired case to change to in Change case to.

Excel change case

You can now see that the case has been changed in the selected columns. No need to ‘run’ anything.

For more information on Case options see the Case documentation.

When you are satisfied with the results you can output the transformed data to a new file in a range of file formats. Ensuring that the blue transform item is selected, click the To File button at the bottom of the Left pane to create a new output file (you might have to scroll down to see the button).

change Excel date format

If you need to change case in lots of Excel sheets you can do it in a single operation using the batch processing feature.

Easy Data Transform allows you to combine multiple transforms, such as Case, to quickly and easily create complex data transformations. For example, you can also combine columns, split columns and merge spreadsheets. Easy Data Transform can input and output in multiple formats, and process millions of rows.

CSV to HTML converter

Try it free now!

Windows Logo Windows Download

v1.22.0 for Windows 11 / 10 / 8 / 7 (38 MB)

Apple Logo Mac Download

v1.22.0 for Mac 12.x to 10.13 (38 MB)


Questions or problems?

Email support@easydatatransform.com