Originally published at: http://www.howtogeek.com/164598/how-to-quickly-and-easily-change-case-in-excel-2013-using-a-function/
You may find you need to change multiple cells from one case to another in Excel. Maybe you imported data that came in all upper case, or maybe you convert headings on columns to upper case. Changing case is easy using some special functions.
Is it possible to convert the text portion of the addresses to uppercase? I am trying to import addresses into our database and it is preferred that all text be inputted in all caps. Thanks
@teresapdiaz, if you have a column of addresses starting in, say D3, in another column place the function "=UPPER(D3)". This will give you the uppercase of that cell. Copy this down as far as needed. Afterward, select the entire column of corrected data, Copy it, then select cell D3, right-click and select "Paste Values". The uppercase data will overwrite the original data. Delete the column you created with the formula in it and proceed to update your database.
How would I do sentence case, where only the first letter of the sentence (or cell) is capitalized?
For capitalizing the first letter of all words in a cell, use "=UPPER(A1)" where you substitute your cell for A1. For capitalizing only the first word in a cell, check this out
Hello, There is another way to change case that may be a little faster. It is pretty much like the example provided but it involves using a blank document. If you have large amounts of text to change case on, this may help.
Simply copy the entire document, or the portion you would like the case changed, open a blank document and paste the data, directly below the data, in the next available row. Type =Proper(A1)(or any other case you desire). Then click the bottom right corner of that cell, and drag to the right until it is the same width as the data above, then click and drag down to match the same length. You will notice all of your data is now changed. You can do this multiple times on the same document if you have a variety of cases you want to go through. From there, you just copy your new case data and paste over into your old document. You could do this in the same document but this keeps it a little bit cleaner.
This operation can be time consuming on large documents in Excel. Hopefully Microsoft will take a page from some of the other open source Office Suites out there and add a menu item in 2015.
Whenever I have to do this, I open up the xls or xlsx file in LibreOffice Calc, select the cells and then pick "Sentence case" from the "Format > Change Case" menu. Then I just save the file.