software

I would like to convert my entire column to uppercase in Excel 97. Is that
possible?

Thank you

Thank you!

quot;jezzica85quot; wrote:

gt; It's definitely possible. For the sake of example, let's just say that
gt; you're working with column A. In Column B, type =UPPER(A1), then copy it
gt; down the column. Then, if you want to keep the original data in Column A,
gt; you're done. If not, copy column B, then go to Paste Special and paste only
gt; the values over column A. You can delete column B once you do that and you
gt; have a perfectly uppercase column. Hope that helps!
gt; Jezzica85
gt;
gt; quot;Jackquot; wrote:
gt;
gt; gt; I would like to convert my entire column to uppercase in Excel 97. Is that
gt; gt; possible?
gt; gt;
gt; gt; Thank you

It's definitely possible. For the sake of example, let's just say that
you're working with column A. In Column B, type =UPPER(A1), then copy it
down the column. Then, if you want to keep the original data in Column A,
you're done. If not, copy column B, then go to Paste Special and paste only
the values over column A. You can delete column B once you do that and you
have a perfectly uppercase column. Hope that helps!
Jezzica85

quot;Jackquot; wrote:

gt; I would like to convert my entire column to uppercase in Excel 97. Is that
gt; possible?
gt;
gt; Thank you

You need a macro to change text constants in place (via a selection)
see Proper, and other Text changes -- Use of SpecialCells
Uppercase
www.mvps.org/dmcritchie/excel/excel.htm#upper
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;jezzica85quot; gt; wrote in message ...
gt; It's definitely possible. For the sake of example, let's just say that
gt; you're working with column A. In Column B, type =UPPER(A1), then copy it
gt; down the column. Then, if you want to keep the original data in Column A,
gt; you're done. If not, copy column B, then go to Paste Special and paste only
gt; the values over column A. You can delete column B once you do that and you
gt; have a perfectly uppercase column. Hope that helps!
gt; Jezzica85
gt;
gt; quot;Jackquot; wrote:
gt;
gt; gt; I would like to convert my entire column to uppercase in Excel 97. Is that
gt; gt; possible?
gt; gt;
gt; gt; Thank you