{"id":1211,"date":"2018-07-02T17:05:43","date_gmt":"2018-07-02T17:05:43","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1211"},"modified":"2023-11-03T15:05:45","modified_gmt":"2023-11-03T15:05:45","slug":"upper","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/upper\/","title":{"rendered":"UPPER function"},"content":{"rendered":"\n
Excel UPPER Function is a handy tool that helps you convert text to uppercase letters in a spreadsheet. It’s especially useful when you want to standardize the capitalization of text, making it all uppercase regardless of how it’s originally typed.<\/p>\n\n\n\n
UPPER(text)<\/strong><\/p>\n\n\n\n Using the UPPER function is quite simple. You provide a cell reference or the text you want to convert to uppercase as the ‘text’ argument. Here are a few examples to illustrate its use:<\/p>\n\n\n\n This formula will return “HELLO” as the output.<\/p>\n\n\n\n If cell A2 contains the text “world,” this formula will return “WORLD” in the cell where it’s entered.<\/p>\n\n\n\n Remember, the UPPER function doesn’t change the original text in the cell. It only displays the uppercase version of the text in the cell where the formula is entered.<\/p>\n\n\n\n Here are a few more examples to show how the UPPER function works:<\/p>\n\n\n\n This formula returns “EXCEL.”<\/p>\n\n\n\n It’s not just limited to alphabetic characters. This formula will return “123ABC” as the result.<\/p>\n\n\n\n If cell A3 contains “MixedCase,” this formula will return “MIXEDCASE.”<\/p>\n\n\n\n Excel UPPER function can be a helpful tool when you need to ensure uniform capitalization in your data, making it easier to work with and present.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel UPPER Function is a handy tool that helps you convert text to uppercase letters in a spreadsheet. It’s especially useful when you…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
text<\/b><\/td> The text you want to convert to uppercase.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
=UPPER(\"hello\")<\/code><\/pre>\n\n\n\n
=UPPER(A2)<\/code><\/pre>\n\n\n\n
Examples<\/h2>\n\n\n\n
=UPPER(\"excel\")<\/code><\/pre>\n\n\n\n
=UPPER(\"123abc\")<\/code><\/pre>\n\n\n\n
=UPPER(A3)<\/code><\/pre>\n\n\n\n