Wednesday, February 19, 2020

UPPER Function in Excel with Example


UPPER ()

This function converts all characters into upper case.

Best view in desktop mode.


A
B
C
1
Original Text
Upper Case
2
alan jones
ALAN JONES
=UPPER(A2)
3
bob smith
BOB SMITH
=UPPER(A3)
4
carOl wiLLiamS
CAROL WILLIAMS
=UPPER(A4)
5
cardiff
CARDIFF
=UPPER(A5)
6
abc123
ABC123
=UPPER(A6)


Syntax

=UPPER(TextToConvert)




Formatting


No special formatting is needed.






                       





No comments:

Post a Comment