![]() |
Capitlize a column?
How can I make a column all capital letters?
|
Capitlize a column?
Hi Austin,
Let say the cell you want to be all capitalized is A1, then you need to put this formula into A2, "=UPPER(A1)" then Copy - Paste Special (Value) into A1. ~jaeson |
Capitlize a column?
Austin Powers formulated on Thursday :
How can I make a column all capital letters? Select the cells in the column that you want to change to uppercase. Run this macro: Sub UpperCase() Application.ScreenUpdating = False Dim c As Range For Each c In Selection c.value = UCase(c.value) Next End Sub -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Capitlize a column?
Unfortunately I am using Excel 2008 for Mac, which does not have VBA...
"GS" wrote in message ... Austin Powers formulated on Thursday : How can I make a column all capital letters? Select the cells in the column that you want to change to uppercase. Run this macro: Sub UpperCase() Application.ScreenUpdating = False Dim c As Range For Each c In Selection c.value = UCase(c.value) Next End Sub -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Capitlize a column?
"Austin Powers" wrote in message
... Unfortunately I am using Excel 2008 for Mac, which does not have VBA... It might have been nice to mention that in your original post. Hopefully you will use this as a learning experience. "GS" wrote in message ... Austin Powers formulated on Thursday : How can I make a column all capital letters? Select the cells in the column that you want to change to uppercase. Run this macro: Sub UpperCase() Application.ScreenUpdating = False Dim c As Range For Each c In Selection c.value = UCase(c.value) Next End Sub -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Capitlize a column?
Austin Powers explained :
Unfortunately I am using Excel 2008 for Mac, which does not have VBA... So.., why have you posted to a programming group if Mac doesn't support VBA??? -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com