change lower-case to upper-case

[cutyfurby]

I input lower-case in the cell and how to return the upper-case.
e.g. I input aaa in the cell and return the AAA
It is not the function upper( ).

 

[Bernard Liengme]

If A1 has the aaa then B1 could have =UPPER(A1) to get uppercase text
But you cannot change the value in the cell A1 with a formula.

If you are doing this to a column of data, you could copy B column and then
use Edit|Paste Special -> Values to replace B's formulas by text and then
delete column A.

 

[aidan.heritage]

As it IS the function Upper I don't understand the question!

 

[Gary]

use ASAP utilities...its an ADD IN.