ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Capitlize a column? (https://www.excelbanter.com/excel-programming/444019-capitlize-column.html)

Austin Powers

Capitlize a column?
 
How can I make a column all capital letters?



DCG-jaeson

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

GS[_5_]

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



Austin Powers

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





BillyBob[_2_]

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






GS[_5_]

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