How do convert an entire column of text in Excel to all caps?

C

Carrie

I'm trying to convert data (a list of names) in a single column to all caps.
I've tried copying and pasting the text from Word, but the data doesn't
change.

I can't get the instructions in Excel help to fix it either....

ARG!!!!
 
C

Chip Pearson

In a column next to your data, enter the formula

=UPPER(A1)

where A1 is the first cell of your data, and then copy down as
far as you need to go. Then copy this result column and paste
special values over your original data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Bernard Liengme

Assume first name is in A1
In B1 (if B is in use, then insert a new B column) enter =UPPER(A1)
Copy formula down to last name (say row 100)
Select B1:B100, click Copy tool; use Edit | Paste Special and check the
Values box
Now the data is not a formula
So now you can delete column A
best wishes
 
C

CLR

In a helper column put this and copy down........then copy > PasteSpecial >
Values to delete the formulas.......

=UPPER(A1)

Vaya con Dios,
Chuck, CABGx3
 
G

Gary''s Student

Say you names are in column A. In an un-used column enter =UPPER(A1) and
copy down. Then copy the new column and paste/special as value back into A
 
D

Dave Peterson

Where is your data?

In Chip's sample formula, he expected it to start in A1.

If your data is in column G, then you can insert a new column H and put:
=upper(g1)

and drag that formula down the column.
 
M

mdonnary

Assuming that your existing name is in column A, use the following
function:

=UPPER(A1)
 
Top