Press the Enter or Return key on your keyboard to apply the formula. Microsoft's Excel spreadsheet program has several functions to make your text type-case consistent. This post will guide you how to change the case of text to uppercase or lowercase in Excel. It will change the text in the cell to all uppercase letters. Assume a scenario where you have a worksheet with the columns contains text with uppercase letters and you wish you convert to lowercase letters in Microsoft Excel 2016. To tell the "UPPER" function which data to convert, click the first cell in your original data column. Click to download Kutools for Excel! In PROPER function the result will always show the first character in capital and rest of the characters will display in non-capital letters. As shown in the image below all the names which we in capital letters are changed to lower case. You can use the function “lower” to do this task. ", "Excellent screen shots, and the step by step was perfect! All tip submissions are carefully reviewed before being published, This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. As shown in the image below all the names which we in capital letters are changed to lower case. Due to this article, within no time I successfully, "This was very helpful with images showing exactly what to do. Share your queries and comments below and I will be more than happy to help. We use cookies to make wikiHow great. If our text is in abc or ABC format we can change it to Abc format using PROPER Function. Can I change to uppercase for an entire working sheet at one time? Excel has many built-in functions related to text operations Text category. 1) … Unlike Microsoft Word, Microsoft Excel doesn’t have a keyboard shortcut for changing the capitalization, or case of selected text. You'll learn how to perform these tasks with the help of Excel lower/upper functions, VBA macros, Microsoft Word, and an easy-to-use add-in by Ablebits. ", "Amazing! Hey, BC. For example, if you want to change all text string in uppercase into lowercase, you can create a formula based on the Lower function. ", "A step-by-step explanation and practical tips! Have you ever heard the old expression, “If you want something done you have to do it yourself”? I was in urgent need of changing my data. Type an equal (=) sign, followed by the word "UPPER" in all capital letters. UPPER Function UPPER function is used to change the text to upper case. wikiHow's. Include your email address to get a message when this question is answered. % of people told us that this article helped them. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8d\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-1-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/8\/8d\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-1-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-2-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-2-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/43\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-3-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/4\/43\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-3-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f1\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-4-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/f1\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-4-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-5-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/4\/4a\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-5-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9c\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-6-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9c\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-6-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c3\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-7-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/c3\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-7-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6a\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-8-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-8-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/6a\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-8-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9e\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-9-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-9-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9e\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-9-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-10-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-10-Version-3.jpg","bigUrl":"\/images\/thumb\/4\/48\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-10-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-11-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-11-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/91\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-11-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/61\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-12-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-12-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/61\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-12-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/99\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-13-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-13-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/99\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-13-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/74\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-14-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-14-Version-3.jpg","bigUrl":"\/images\/thumb\/7\/74\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-14-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-14-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/89\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-15-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-15-Version-3.jpg","bigUrl":"\/images\/thumb\/8\/89\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-15-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-15-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b7\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-16-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-16-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/b7\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-16-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-16-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c7\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-17-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-17-Version-3.jpg","bigUrl":"\/images\/thumb\/c\/c7\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-17-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-17-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f2\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-18-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-18-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/f2\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-18-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-18-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0c\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-19-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-19-Version-3.jpg","bigUrl":"\/images\/thumb\/0\/0c\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-19-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-19-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2b\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-20-Version-2.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-20-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/2b\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-20-Version-2.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/27\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-21-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-21-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/27\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-21-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-21-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d8\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-22-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-22-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d8\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-22-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-22-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/25\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-23-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-23-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/25\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-23-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-23-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/45\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-24-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-24-Version-3.jpg","bigUrl":"\/images\/thumb\/4\/45\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-24-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-24-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f8\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-25-Version-3.jpg\/v4-460px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-25-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/f8\/Change-from-Lowercase-to-Uppercase-in-Excel-Step-25-Version-3.jpg\/aid4221623-v4-728px-Change-from-Lowercase-to-Uppercase-in-Excel-Step-25-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"