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

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

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

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

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

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 ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar