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.

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.

"MT NATIVE" wrote:

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.

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"MT NATIVE" <MT wrote in message
...
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.