Converting Text to Uppercase





Use the UPPER function to convert text to uppercase.

The UPPER function is in the Text category in the Insert Function dialog box.

Example:

Text in lowercase: george w. bush
The function: =UPPER(A1)
Result: GEORGE W. BUSH
Screenshot // Converting Text to Uppercase
Converting Text to Uppercase



6 thoughts on “Converting Text to Uppercase

  1. This tip works when converting a single cell, but I cannot find how to convert an entire worksheet like I can in WORD. I tried entering =UPPER(A1:J254) but it did not work. My data list is a chart of names and addresses with columns of figures and I want to change the text parts to upper case.

  2. when I enter this formula I get a circular reference. How do I get rid of that. I also would like to convert entire columns at one time. Anyone got the solution.

  3. This tip works when converting a single cell, but I cannot find how to convert an entire worksheet like I can in WORD. I tried entering =UPPER(A1:J254) but it did not work. My data list is a chart of names and addresses with columns of figures and I want to change the text parts to upper case.

  4. I could not get this to work at all. If any one know a way to convert entire columns to upper case, it would save me a lot of time. thanks.

  5. “1 if u want column a from 1-10 then copy cell a1 to b1
    2 apply upper formula
    3 copy formula in b1 to all rows till b10
    4 copy b1-b10 and paste-special–> values at position a1
    UPPPER CASE FOR COLUMNS
    WBl77 Posted on: 31-12-1969
    YOU CAN USE THE UPPER FORMULA ON THE FIRST CELL, AND THEN USE THE SMALL + AT THE BOTTOM OF THE CELL TO GO TO THE BOTTOM OF THE COLUMN. THIS WILL REPLACE ALL OF THE VALUES IN THE FORMULA WITH THE CELL NUMBERS FOR THE RANGE YOU HIGHLIGHT. THEN JUST REPEAT FOR EACH COLUMN”

Leave a Reply

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


− 3 = six

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>