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
|