Excel users frequently want to change case in one or more columns. For example to turn:
Into:
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 to update. You also lose the data that was there before.
However it is very easy to change case in Easy Data Transform:
A blue transform item is added and selected.
In the right pane select the column(s) you wish to change and the desired case to change to in Change case to.
You can now see that the case has been changed in the selected columns.
When you are happy with the results output the result into a new Excel spreadsheet or CSV file.
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.
v1.11.2 for Windows 10 / 8 / 7 (50 MB)
v1.11.2 for Mac 11.1 to 10.12 (25 MB)
Questions or problems?
Do you have a question?
We would love to help.
This pop-up will not be shown again