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