Change text to Upper Case in Excel – Easy Guide 2021 series

Although Excel is primarily used for Calculations, but has several in-built options to handle text also. Functions like UPPER, LOWER and PROPER can be used to covert text content in upper case, lower case or proper case. In this guide we will go through usage of UPPER function to convert text to upper case in Excel.

Use UPPER Function to change text to upper case in Excel

UPPER function converts provided text string to upper case. One can provide cell reference or text string directly as input. UPPER function ignores numbers, punctuations and spaces. In case number is given as input it will remove number formatting and convert it to text formatting, although number will remain same. Also if input is date then UPPER function will convert it to date serial number.

Syntax

UPPER(text or cell reference for text)

Example

Convert text string to upper case using UPPER Function

Here directly text string is provided as input to text function. In below example “tom” has been provided as input to UPPER function.

Example

UPPER("tom")

This will give output as TOM in upper case. Here UPPER function is used to change text to upper case in Excel

Change Text to UPPER case in Excel

Convert to upper case using UPPER Function with cell reference as input

Here text string is input as cell reference, suppose input text is in cell A1 below syntax will be used

Example

UPPER(A1)

Convert to upper case using UPPER Function when input is text with numbers

Mixed input i.e. text with number can also be provided as input to UPPER function in excel. UPPER function will ignore punctuations, numbers and spaces.

Example

UPPER(a1-b2 c3 d4 e5) 

Output of above will be “A1-B2 C3 D4 E5”

Convert Date to upper case using UPPER function in Excel

Converting date to upper case is not as straight forward

Example

Input is 26-Sep-2021 then you will get output as 26-SEP-2021

Syntax

UPPER("26-Sep-2021")

But in case you are using cell reference for date with UPPER function directly on Date it will give you Date serial as output.

So if your cell A1 has 26-Sep-2021 and you use function UPPER(A1) in above case output will be “4465”.

Here you will have to use TEXT function along with UPPER Function.

Syntax

UPPER(TEXT(A1,"dd-mmm-yyyy"))

Change number formatting to Text formatting using UPPER function in Excel

If number is provided as input to UPPER function in Excel it will change formatting from number to text.

Syntax

UPPER(A1) where cell A1 has number

UPPER(“26”) where number 26 is directly given as input.

Things to Note

  1. UPPER function is used to change text to upper case in Excel.
  2. If number is given as input number formatting will be removed and will be converted to text format.
  3. UPPER function ignore numbers, punctuations and spaces.

Other Posts which may interest you

Top 7 text functions in excel