Text function

Excel LOWER function

Q: How do I make all text lowercase in Excel?

Type =LOWER(A2) in a new column, fill it down, then copy and Paste Values over the original data.

Q: How do I check if two cells match ignoring case?

A plain =A2=B2 already ignores case. Use EXACT(A2,B2) if you need a case-sensitive check.

LOWER converts every letter in a text value to lowercase. Use it to clean up email addresses, build usernames, or make tags consistent before you share or import a list.

=LOWER(text)

Arguments

text: The text or cell to convert to lowercase.

LOWER examples

Every result below was calculated from this sample sheet by the same spreadsheet engine the Cellwise app uses.

	A	B	C	D
1	First	Last	Email	Tag
2	Hannah	Okafor	Hannah.Okafor@Gmail.com	NEWSLETTER
3	Luis	Moreno	LMORENO@OUTLOOK.COM	Trial
4	Ellie	Brandt	ellie@brandt.dev	Customer

=LOWER(C3)
Result: lmoreno@outlook.com
Cleans up a shouty email address to "lmoreno@outlook.com".
=LOWER(D2)
Result: newsletter
Makes tags consistent: "newsletter".
=LOWER(LEFT(A2,1)&B2)
Result: hokafor
Builds a username from the first initial and last name: "hokafor".

How to use LOWER

Click an empty cell beside your data.
Type =LOWER( and select the cell.
Close the bracket and copy it down.
Paste the results as values if you want to replace the originals.

Common LOWER mistakes

Assuming it fixes spacing

LOWER only changes case. Wrap it with TRIM to remove extra spaces too: =LOWER(TRIM(A2)).

Deleting the source column too soon

The formula depends on the original. Paste as values first, then delete.

LOWER FAQ

How do I make all text lowercase in Excel?

Type =LOWER(A2) in a new column, fill it down, then copy and Paste Values over the original data.

Are email addresses case sensitive?

In practice, no. Mail providers treat them the same, so lowercasing them with LOWER is a safe way to remove duplicates.

How do I check if two cells match ignoring case?

A plain =A2=B2 already ignores case. Use EXACT(A2,B2) if you need a case-sensitive check.