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
Tuesday, March 22, 2005

SecurityWe recently posted new security and privacy policies  to the ITS website.  The policies were reviewed and approved by the Information Technology Committee (ITC) in Fall 2004 in preparation for the NCA visit.  The policies are worth reviewing to understand how the security environment is changing and how ITS is working with the rest of the campus to balance concerns of security, privacy, academic freedom and campus culture.  See the Policies  tab for more information.
Login Button