The Excel UPPER function
returns a upper-case version of a given text string. Numbers and punctuation
are not affected.
Syntax
The syntax for the UPPER
function in Microsoft Excel is:
UPPER(
text )
Parameters or Arguments
text
The string that you wish to
convert to uppercase.
Upper Function Examples
Column B of the following
spreadsheet shows the Excel Upper function, used to convert four text strings
to upper case:
Formulas:
|
|
A
|
B
|
|
1
|
test
|
=UPPER(
A1 )
|
|
2
|
TEST
|
=UPPER(
A2 )
|
|
3
|
Test
|
=UPPER(
A3 )
|
|
4
|
test 332
|
=UPPER(
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