Excel Upper Function

This post will guide you how to use Excel UPPER function with syntax and examples in Microsoft excel.

Description

The Excel UPPER function converts all characters in text string to uppercase.

The UPPER function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The UPPER function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000.

Syntax

The syntax of the UPPER function is as below:

= UPPER (text)

Where the UPPER function arguments are:
Text -This is a required argument. The text that you want to converted to uppercase.

Example

The below examples will show you how to use Excel UPPER Text function to convert all characters in text string to uppercase.

#1 To convert all characters to uppercase in B1 cell, just using formula:= UPPER(B1).

excel upper function example


More Related UPPER Function Examples

  • Change Uppercase and Lowercase Text
    if you want to change all text string in uppercase into lowercase, you can create a formula based on the Lower function. And if you want to convert all letters in one cell into uppercase, you can use the Upper function as a formula in excel.…
Related Posts

How To Convert Text to Upper Cases(Using VBA) in Excel
convert text to upper cases1

This post will show you how to switch from lower case to upper case in Excel. and I am going to show you two different ways of converting text to upper cases using formula or VBA macro in Excel 2013,Excel ...

How to Convert Uppercase to Lowercase Except the First Letter in Excel
Convert Uppercase to Lowercase 4

In excel, words can be entered in uppercase, lowercase or mixed. If we want to convert all uppercase to lowercase (except the first letter in some situations), we can use formula with some letter convert related functions to convert them ...

How To Force Text String to Upper,Lower, or Proper Case in Excel
force text string to upper lower proper7

This post will guide you how to force test strings to uppercase or lowercase or Proper cases through an Excel formula or data validation in your Excel 2013/2016. How to convert text to upper, lower, or proper case in Excel. ...

How to Check If a Cell is Uppercase, Lowercases or Capitalize in Excel
check letters uppercase2

This post will guide you how to check if a cell is uppercase in Excel 2013/2016. How do I identify all letters in cells are lowercases or capitalize in Excel. How to change letters to uppercase, lowercases or capitalize first ...

Convert Scientific Notation to Text or a Number in Excel
convert scientific notation to text7

This post will guide you how to convert scientific notation to text or a number in Excel. How do I convert excel scientific to text with a formula in Excel. Convert Scientific Notation to Text or a Number in Excel ...

Change Uppercase and Lowercase Text
change uppercase to lower3

This post will guide you how to change the case of text to uppercase or lowercase in Excel. How do I change all uppercase text to lower case with an Excel formula. For example, if you want to change all ...

How to Check If the First Letter is capitalized
check if first letter capitalized4

This post explains that how to check if the first letter in a cell is capitalized or not in excel. How to write an excel Macro to check if the first letter in a specified cell is capitalized or not. ...

The difference between Replace function and Substitute function in Excel
The difference between Replace function and Substitute function1

There are two similar functions to replace text string in Excel. They are REPLACE and SUBSTITUTE functions. What’s the difference between REPLACE function and SUBSTITUTE function in excel 2013?  This post will introduce the difference between those two function in ...

Excel Replace Function Remove Text String
Excel Replace Function Remove Text String1

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Combining the REPLACE Function with FIND Function to Remove Text in Excel
Combining the Replace function with Text function 2

How to remove a text string or characters from a cell when the text is at a specific position. And this post will guide you how to remove a text string from a cell or column that the removed text ...

Sidebar