A
Austin Powers
How can I make a column all capital letters?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DCG-jaeson
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
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
G
GS
Austin Powers formulated on Thursday :
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
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
A
Austin Powers
Unfortunately I am using Excel 2008 for Mac, which does not have VBA...
B
BillyBob
Austin Powers said: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.
G
GS
Austin Powers explained :
So.., why have you posted to a programming group if Mac doesn't support
VBA???
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???