Google Sheets

LOWER: Google Sheets Formulae Explained

How do you use LOWER in Google Sheets?

I use LOWER to change the capitalization of text in Google Sheets. For example, if I have a column of text that is all in capital letters, I can use the LOWER function to change the text to lowercase. This is helpful when I want to make sure all of the text in my spreadsheet is consistent in terms of capitalization.

What is the syntax of LOWER in Google Sheets?

LOWER is a function in Google Sheets that takes a string as an input and converts it to lowercase. The syntax is LOWER(string), where "string" is the text that you want to convert to lowercase.

What is an example of how to use LOWER in Google Sheets?

To use LOWER in Google Sheets, you can simply type =LOWER() into a cell and hit enter. This will return the text in that cell lowercased.

When should you not use LOWER in Google Sheets?

There are a few instances when you should not use LOWER in Google Sheets. If you are working with text that already has proper capitalization, using the LOWER function will result in all of the text being converted to lowercase. This can be confusing and inconsistent, so it is best to avoid using LOWER in this type of situation. Additionally, the LOWER function is not case-sensitive, so it will not differentiate between lowercase and uppercase letters. This can cause problems if you are trying to compare two pieces of text that differ only by case.

What are some similar formulae to LOWER in Google Sheets?

There are a few similar formulae to LOWER in Google Sheets. One is LOWERCASE(), which will convert a string of text to lowercase. Another is PROPER(), which will convert a string of text to proper case. Finally, there is SUBSTITUTE(), which will replace a given substring with another substring.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.