convert text to all upper case without having to retype everythin.

[MT NATIVE]

I am new at excel and would like to know how I can convert text to all upper
case letters without having to retype everything.

 

[trip_to_tokyo]

Here is an example in EXCEL 2007:-

1. In cell A 1 type:-

aaaa

2. In cell B 1 type:-

=UPPER(A1)

AAAA will now appear in cell B 1.

If my comments have helped please hit Yes.

Thanks.

 

[Bernard Liengme]

Suppose I have a column with text values
Let this be column A; so insert a new column B (right click the B header and
use Insert)
In A1 enter the formula =UPPER(A1)
Copy this formula down the column. The fastest way is to double click B1's
fill handle - small solid square in B1's lower right cornet when B1 is
selected)
Now select all you formulas in B and use the Copy command
With them still select use Edit | paste Special with Values specified. This
turns will the formulas into values.
Now you can deleted column A
best wishes