Saturday, January 14, 2012

How to Convert a Column to All Caps in Excel


1. Open the Microsoft Excel document that contains the column of data that you want to convert to all caps. Open a second blank Microsoft Excel document as well.
2. Highlight the entire column in the Excel document that you want to convert to all caps. Note that if you want to convert several columns to all caps, you must repeat this process for each column; you can only change one column at a time using this method.
3. Right-click the highlighted data and select 'Copy.' Minimize the Excel document and maximize the blank Excel spreadsheet.
4. Right-click in cell 'A1' in the top left corner of the spreadsheet and select 'Paste.' The data will transfer to the blank document.
5. Input the following formula in cell 'B1' in the spreadsheet you just copied the data to:=UPPER(A1)Cell 'B1' will now contain an all-caps version of cell 'A1.'
6. Hold your cursor at the bottom right corner of cell 'B1' until it changes from a white cross to a black cross. Click and drag downward, highlighting the same number of cells as the 'A' column. The 'B' column will populate with the all-caps version of the 'A' column.
7. Highlight all of the cells that contain values in column 'B,' right-click and select 'Copy.'
8. Maximize the original document, and highlight the column that you highlighted in Step 2.
9. Right-click the highlighted selection and choose 'Paste Special.' A dialog box will appear. Select 'Values' and click 'OK.' Excel will replace the original values in the column with the all-caps version of the values.

Blogger news