Our guide below will show you how to use this formula, then replace your original lowercase data with the uppercase data that you need.Ĥ Additional Reading How to Make All Text Uppercase in Excel 2013 So if you have a spreadsheet of data that is all lowercase, or is a mixture of lowercase and uppercase, you may be looking for a way to make all of the text uppercase in Excel 2013.įortunately, you can accomplish this with the help of a formula that can automatically make all of your text uppercase. Uppercase typing may have negative connotations when used conversationally in text messages or emails, but there are certain types of databases or situations where your data needs to be in all capital letters. You can then copy and paste the values from the formula to replace the existing lowercase or sentence case data.
Thie re-entry is also prone to error, and it can be frustrating to perform a lot of work simply because you need to switch some formatting.įortunately, you can use the =UPPER(XX) formula to convert existing text to uppercase in Excel 2013. SelectedCells.Value = UCase(SelectedCells.If you have ever needed to re-enter a large amount of data in a spreadsheet then you know how tedious it can be.
Without wasting much time, below is the code that will convert your text to either capital or small letters.įor Each SelectedCells In Selection.Cells Doing this in Microsoft Word is very simple with a few clicks, but with Excel, things are different and tricky. How to capitalize in Excel with VBAĪs I already mentioned, with the use of VBA code, you can select a range of cells or the entire worksheet and change it to whatever case you like. After that, we’ll then learn how to do it using Functions. Because you’ll have to change each and every column one after the other for all the columns.īut if the text you want to capitalize is in only one or two columns, then I think using functions will be so much convenient and faster.įirst of all, let’s talk about how to capitalize in Excel using VBA. So if you have more than 10 rows in your worksheet there’s more work for you. But rather you’ll have to change them column by column or row by row using the functions. Without the use of the VBA code, you cannot capitalize on a selected range of cells at once.
You can use functions to capitalize in Excel and you can also use some VBA code to do the same.īut I personally prefer using Excel VBA because it makes it possible and easy to capitalize an entire worksheet or a selected range of cells. With the PROPER function, every letter will be converted to lowercase except for the first letter of each word. The LOWER function, on the other hand, converts text to lowercase.Īnd the PROPER function converts text to the initial case. The UPPER function converts text from lowercase to upper case letters. There are three inbuilt Excel functions purposely for changing cases: The UPPER function, the LOWER function, and the PROPER function. You know in Microsoft Word, you can simply do all this stuff with just a few clicks. It is also possible to change the case so that only the first letters in each word will be capitalized. In this tutorial, I want to focus on how to change the cases of text in Excel.įor instance, you want to change the text from lower case to upper case.
If you haven’t yet, you’ll soon come across a situation through your journey with excel, where you’ll want to manipulate text by changing the case, I mean capitalization.