Capitlize a column?

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
 
G

GS

Austin Powers formulated on Thursday :
How can I make a column all capital letters?
Click to expand...

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
 
B

BillyBob

Austin Powers said:
Unfortunately I am using Excel 2008 for Mac, which does not have VBA...
Click to expand...

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 :
Unfortunately I am using Excel 2008 for Mac, which does not have VBA...
Click to expand...

So.., why have you posted to a programming group if Mac doesn't support
VBA???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Outlook AutoCorrect with GPO 0
Need a macro to create a separate document that lists all capitalized words 6
Word isn't capitalizing the first word of each sentence 2
Code snippet works but is a bit 'clumbsy' 3
dont want automatic capitalizaing 1
Mail Merge Directory Conditional Page Break 0
Unwanted spaces 4
Insert name and adress from a list in a word document 1

Top