How can I make a column all capital letters?

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

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

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

"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

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