The Microsoft Excel LOWER
function converts all letters in the specified string to lowercase. Numbers and punctuation are
not affected.
Syntax
The syntax for the LOWER
function in Microsoft Excel is:
LOWER(
text )
Parameters or Arguments
text
The string to convert to
lowercase.
Lower Function Examples
In the spreadsheet below, the Excel Lower function is
used to convert four text strings to lower case:
Formulas:
|
|
A
|
B
|
|
1
|
test
|
=LOWER(
A1 )
|
|
2
|
TEST
|
=LOWER(
A2 )
|
|
3
|
Test
|
=LOWER(
A3 )
|
|
4
|
TEST 332
|
=LOWER(
A4 )
|
Results:
|
|
A
|
B
|
|
1
|
test
|
test
|
|
2
|
TEST
|
test
|
|
3
|
Test
|
test
|
|
4
|
TEST 332
|
test 332
|
Reference:
follow us on http://arivilm.blogspot.in
like us on https://www.facebook.com/Arivilm2501/
No comments:
Post a Comment