Advertisements

Excel UPPER Function

The Excel UPPER Function is used to change the lowercase of text to uppercase. The UPPER Function does not affect Numbers, Punctuation, Spaces, and the date format is lost.

In this section:

Advertisements

  1. Syntax of UPPER Function
  2. Example 1: Convert all letters to uppercase.
  3. Example 2: Use UPPER and CONCAT to join names with UPPERCASE.
  4. Example 3: Convert dates to UPPER case letters with TEXT Function.

Excel UPPER Function to convert letters to uppercase.

1. Syntax of UPPER Function:

UPPER(text)

where:

2. Convert all letters to UPPERCASE:

To convert all letters to UPPERCASE, the formula (in cell D6) is =UPPER(C6), which converts all letters except number, space, and dates, to uppercase.

Excel UPPER Function to convert all letters to uppercase.

3. Join first and last names with UPPER and CONCAT:

To join first and last names with UPPERCASE letters, the formula, in combination with CONCAT, is =UPPER(CONCAT(C6,” “,D6)), which joins the first and last names with UPPER case letters.

Excel UPPER Function

4. UPPER Function with dates:

To convert dates to uppercase, users have to combine UPPER and TEXT Function as =UPPER(TEXT(C6, “mmm d, yyyy”)), which convert the date to UPPER case.

Excel UPPER Function

More related readings:

Advertisements
  1. MS Office post on UPPER Function
  2. Excel CONCAT Function
  3. Extract first Name in excel (3 practical examples)
  4. Extract Middle names (3 practical examples)
  5. Excel ARRAYTOTEXT Function
  6. Excel CLEAN Function with practical examples
  7. Excel CONCAT Function to join text
  8. Excel REPLACE Function to replace text
  9. Excel TRIM Function with Practical Examples
  10. Excel RIGHT Function
  11. How to generate tomorrow’s date in Excel

One Response

  1. What i don’t understood is in reality how you are no longer really a lot more smartly-preferred than you may be now. You are very intelligent. You recognize thus considerably with regards to this subject, produced me personally believe it from so many various angles. Its like women and men don’t seem to be fascinated unless it is one thing to do with Girl gaga! Your personal stuffs nice. All the time deal with it up!

Leave a Reply

Your email address will not be published. Required fields are marked *

Advertisements