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

Table of Contents

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

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

## Leave a Reply

You must be logged in to post a comment.