December 4, 2020

LOWER function in Google Sheet

The LOWER function converts the upper case texts to lower case in Google Sheet.

 =LOWER(text)
  • text: This is the string in which you want to convert upper case characters to lower case.

Below is the example of LOWER function applied on the strings in cell A2, A3 & A4 to convert all the upper case characters to lower case in cell B2, B3 & B4 respectively.

Now we will see how to create email address with first and last name in Google Sheet.

In the below example, Column A contains the list of first names. Column B contains the list of respective last names. We have used the below formula to create email id in format <first name>.<last name>@xyz.com

=LOWER(A2)&"."&LOWER(B2)&"@xyz.com"

Here the LOWER function converts the upper case letters in first name and last name into lower case. Here we used ‘&’ to merge multiple set of texts to create the email address string.

Note:

  1. The LOWER function only affects the uppercase characters of the string. Any character other than the uppercase text is left unchanged.
  2. Numbers, special characters & punctuations are not changed by the LOWER function.
  3. If you use a null character (or refer to an empty cell), it will return a null character.

Check here to learn the LOWER function in Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *