Can I make an entire column Uppercase?
 

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

Thank you

Can I make an entire column Uppercase?
 

Thank you!

"jezzica85" wrote:

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

"Jack" wrote:

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

Thank you

Can I make an entire column Uppercase?
 

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

"Jack" wrote:

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

Thank you

Can I make an entire column Uppercase?
 

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

"jezzica85" wrote in message ...
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

"Jack" wrote:

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

Thank you