I used the following technique to convert a column of text to UPPER CASE.

1. Move the cursor to a blank column.
2. In the empty cell on the same row as the first cell you want to convert, type "=upper(A3)", if A3 is the first cell you want to convert.
3. The previously empty cell should now show the upper case equivalent of your first cell of text.
4. Copy this cell down the column to the same height as all of your text.
5. You should now have a column equivalent to your text, but all in UPPER CASE.
6. Highlight all of the cells of UPPER CASE text, and select copy.
7. Left click on the first cell of your source text (which is not in upper case), which will select the cell.
8. Right click.
9. Select Paste Special
10. In the list box, select "Values" radio button, and click OK.
11. You will now have 2 columns of upper case text.
12. Delete the column containing the =upper() formulas.

The same principle works for Proper, and other text manipulation functions.

I used the following technique to convert a column of text to uppercase.

1. Move the cursor to a blank column.
2. In the empty cell on the same row as the first cell you want to convert, type =upper(A3), if A3 is the first cell you want to convert.
3. The previously empty cell should now show the upper case equivalent of your first cell of text.
4. Copy this cell down the column to the same height as all of your text.
5. You should now have a column equivalent to your text, but all in uppercase.
6. Highlight all of the cells of uppercase text, and select copy.
7. Left-click on the first cell of your source text (which is not in uppercase), which will select the cell.
8. Right-click.
9. Select Paste Special
10. In the list box, select "Values" radio button, and click OK.
11. You will now have 2 columns of upper case text.
12. Delete the column containing the =upper() formulas.

The same principle works for Proper, and other text manipulation functions.