Skip to content

Excel function · Text

Excel LOWER function

LOWER converts every capital letter in a text to lower case. It is used to make email addresses, web addresses and tags typed in different ways consistent.

In Turkish Excel: KÜÇÜKHARF

What it does

LOWER takes a single argument and returns a lower-case copy of the text; digits and symbols are unchanged. For information that should be stored in lower case, such as email addresses, domains and usernames, it makes lists typed by different people consistent.

Case makes no difference to Excel's comparisons: COUNTIF treats "LONDON" and "london" as the same. To compare with case, use EXACT. For names and titles where the first letters should stay capitalised, PROPER is the better fit.

A few letters convert differently by language. In Turkish, the lower case of I is ı (without a dot), so on a computer with Turkish language settings an address such as "INFO@" can come out wrong. If your file will be used there, replace I with i first: =LOWER(SUBSTITUTE(A2,"I","i")).

Syntax

English Excel=LOWER(text)
Turkish Excel=KÜÇÜKHARF(metin)

Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.

Arguments

ArgumentRequiredDescription
textRequiredThe text, or cell, to convert. Characters that are not letters stay as they are.

Examples

1Lower-case email addresses typed in capitals

The addresses come from different sources in different cases. Column B converts all of them to lower case; the @ and the dots do not change.

B2fx=LOWER(A2)
Lower-case email addresses typed in capitals: example table
AB
1Address as TypedAddress
2SALES@NORTHGATE.COMsales@northgate.com
3Accounts@HarbourTrade.co.ukaccounts@harbourtrade.co.uk
4SUPPORT@STARMARKET.COMsupport@starmarket.com
5Hr@BrownAndSons.co.ukhr@brownandsons.co.uk
  • B2 (filled down to B5)=LOWER(A2)

B2 shows sales@northgate.com and B3 shows accounts@harbourtrade.co.uk.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

2Lower-case and trim in one step

Some addresses were pasted with spaces around them. TRIM removes the spaces and LOWER converts the letters.

B2fx=LOWER(TRIM(A2))
Lower-case and trim in one step: example table
AB
1Address as TypedAddress
2 Sales@Northgate.comsales@northgate.com
3ACCOUNTS@HARBOURTRADE.CO.UK accounts@harbourtrade.co.uk
4 Support@StarMarket.comsupport@starmarket.com
5HR@BROWNANDSONS.CO.UKhr@brownandsons.co.uk
  • B2 (filled down to B5)=LOWER(TRIM(A2))

B2 shows sales@northgate.com and B3 shows accounts@harbourtrade.co.uk, ready to be matched against another list.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

Common errors and fixes

Address still does not match

Cause: Converting to lower case does not remove spaces at the start or end of the address.

Fix: Use =LOWER(TRIM(A2)).

Dotless ı appears

Cause: With Turkish language settings, the capital I can turn into the dotless ı, which breaks addresses such as "INFO@".

Fix: Replace I first: =LOWER(SUBSTITUTE(A2,"I","i")).

Good to know

  • To make the cleaned addresses permanent, copy the results and paste them over the source column with Paste Values.
  • To find addresses that contain capitals, add a column with =EXACT(A2,LOWER(A2)) and filter for FALSE.

In Nexell

Get Nexell to do it from a sentence

Type this in Nexell

Add a column that converts the email addresses to lower case and removes stray spaces

Convert to table

Bring your address list into the tool and type this. Nexell writes the cleaned addresses into a new column and shows them in a preview first; the source column stays as it is.

Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.

Free account · no card needed · 30 credits a month

Frequently asked questions

How do I convert email addresses to lower case?

=LOWER(TRIM(A2)) lowers the letters and removes spaces at the start and end in one go. Fill it down, then paste the results as values if you want to replace the original column.

What is the difference between LOWER and PROPER?

LOWER makes every letter lower case. PROPER capitalises the first letter of each word and lowers the rest; use it for names and cities.

Related functions

All text functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free