LOWER Function in Excel with Example

LOWER ()

This function converts all characters into lower case.

 Best view in desktop mode.

	A	B	C
1	Text	Lower Case
2	ALAN JONES	alan jones	=LOWER(A2)
3	Bob Smith	bob smith	=LOWER(A3)
4	CAROL WILLIAMS	carol williams	=LOWER(A4)
5	Cardiff	cardiff	=LOWER(A5)
6	ABC123	abc123	=LOWER(A6)

Syntax

=LOWER(TextToConvert)

Formatting

No special formatting is needed.

RIGHT in Excel

<<  Previous

Next  >>

UPPER in Excel