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
Thursday, August 20, 2009

WiFi may be slower than a wired network, but you can't beat the convenience.  As more and more students faculty and staff make extensive use of campus WiFi access, the pressure has grown to make it available everywhere. So, last spring ITS received approval to move ahead with a plan to implement a campus-wide enterprise wireless system over the course of academic year 2009-10.  The first fruits of that project are already installed in Miller dorm, and by mid-September ITS plans to have coverage in the entire KMY complex, the Union Building and Westlawn.  Other residence halls will come online during fall semester.  We'll post additional status reports as we make progress on the implementation
Login Button