{"id":1171,"date":"2018-07-01T15:10:37","date_gmt":"2018-07-01T15:10:37","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1171"},"modified":"2023-11-03T10:07:43","modified_gmt":"2023-11-03T10:07:43","slug":"lower","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/lower\/","title":{"rendered":"LOWER function"},"content":{"rendered":"\n
The LOWER function in Excel is used to convert text to all lowercase letters. It’s a simple yet handy function that can be useful in various scenarios where you need to standardize the case of text data.<\/p>\n\n\n\n
LOWER(text)<\/strong><\/p>\n\n\n\n To use the LOWER function, follow this simple syntax: Let’s take a look at a few examples:<\/p>\n\n\n\n Example 1:<\/b> Suppose you have the text “Hello World” in cell A1. To convert it to all lowercase, use the formula:<\/p>\n\n\n\n The result will be “hello world.”<\/p>\n\n\n\n Example 2:<\/b> If you want to apply the LOWER function to a text string directly, you can use it like this:<\/p>\n\n\n\n The result will be “excel functions.”<\/p>\n\n\n\n Example 3:<\/b> You can also use the LOWER function within other formulas. For instance, if you have a text string in cell B1 and you want to concatenate it with another string in cell C1 while ensuring it’s in lowercase, you can use the formula<\/p>\n\n\n\n Remember that the LOWER function doesn’t affect numbers or special characters, it only converts alphabetical characters to lowercase.<\/p>\n\n\n\n The LOWER function is a part of Excel’s arsenal of text manipulation functions, which can be particularly helpful when working with textual data. It’s a non-destructive function, meaning it doesn’t change the original text; it only provides a lowercase version of it. Whether you’re dealing with data cleaning, data analysis, or preparing text for other functions, LOWER can be a valuable tool.<\/p>\n","protected":false},"excerpt":{"rendered":" The LOWER function in Excel is used to convert text to all lowercase letters. It’s a simple yet handy function that can be…<\/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 lowercase.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=LOWER(text)<\/code>, where “text” is the cell reference or the text you want to convert to lowercase.<\/p>\n\n\n\n
=LOWER(A1)<\/code><\/pre>\n\n\n\n
=LOWER(\"Excel Functions\")<\/code><\/pre>\n\n\n\n
=LOWER(B1) & \" \" & C1<\/code><\/pre>\n\n\n\n
Additional information<\/h2>\n\n\n\n