PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-UPPER

INTRODUCTION

UPPER function comes under the TEXT category in Excel.

UPPER FUNCTION converts lower case to upper case of the given text. It can be used in any situation or forms where we need the text to be in the upper case only.

PURPOSE OF upper FUNCTION IN EXCEL

UPPER FUNCTION converts lower case of the text to upper case.

 
 

PREREQUISITES TO LEARN UPPER

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: UPPER FUNCTION

The Syntax for the function is

=UPPER(TEXT STRING)

TEXT STRING   GIVEN TEXT

 

 

EXAMPLE:UPPER FUNCTION IN EXCEL

DATA SAMPLE

The string is “ONCE UPON A TIME there was  A KING”. We will try to convert it to upper case with the help of UPPER FUNCTION.

EXCEL FUNCTION UPPER
EXCEL:UPPER FUNCTION EXAMPLE

STEPS TO USE UPPER FUNCTION

The text having mixed cases (upper and lower) is present in cell G9.

To convert it to upper case we have put a formula

=UPPER(G9) in H9 and the result is as expected.

The output has all upper letters.

“ONCE UPON A TIME THERE WAS A KING.”

OTHER WAYS TO REACH THIS ARTICLE

  • UPPER FUNCTION, CONVERT LOWER CASE TO UPPER CASE IN EXCEL, UPPER CASE CONVERSION IN EXCEL

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: