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

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.

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

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.

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

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.