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.