Did you know that there are 3 simple formulas you can use to change the text formatting in Excel?
It’s true!
Excel is a great tool which was originally created for numerical spreadsheets.
Although it’s great for keeping data, it can fall short in its abilities with things like grammar, spelling, and formatting.
That’s why this handy tip to help you change the formatting of your data, particularly when working on large amounts of data at a time, is so helpful.
Watch the below video on how to change the format of text in an Excel spreadsheet quickly and efficiently.
So that is how to change the text formatting in Excel. I have written down below the formulas I’ve used in the above video for you to easily refer to.
Make sure you watch the video to see how to copy the info from the cell to replace the original text so you no longer have the formula in the background of your spreadsheet.
To format text to have the first letter of each word with a capital letter:
=proper(cell)
To format text to have all letters upper case:
=upper(cell)
To format text to all be in lower case:
=lower(cell)