Tip: Change the Case of Text in Excel


Assuming that column A, cells 1 through 5 contain the text you wish to convert to all uppercase:
  • Insert a column to the right of column A by selecting column B and clicking Columns on the Insert menu. (You don't need to do this if column B is empty.)
  • Type the following formula in cell B1
    =UPPER(A1) 
  • In column B, select all the cells to the right of the cells that contain data in column A. In this example it would be cells B1 through B5.
  • On the Edit menu, point to Fill, and then click Down.  Column B now contains the uppercase version of the text in column A.
  • With the same range selected, click Copy on the Edit menu.
  • Select cell A1, and click Paste Special on the Edit menu.  In the Paste Special window, click Values, and click OK to past the converted values back on top of column A.
  • Delete the contents of column B. (If this was a column you inserted, delete the entire column by selecting the column and clicking Delete on the Edit menu.
You can do the reverse of changing text to all lower case by substituting the formula with =LOWER(cell range). 


News Archive
Wednesday, July 19, 2006
WiFi ITS installed GC's first wireless access point back in 1999.  Since then, the GC WiFi network has grown steadily to the point where there is coverage in all academic buildings and most green spaces.  One of this summer's project is to extend the WiFi network to all the dorm public lounges. This complements the full coverage placed in the new senior apartments and the Connector in recent years.  So go ahead, get mobile!
Login Button