change lower case text to upper case text

[Guest]

is it possible to change lower case text to upper case text in microsoft
excel 2000

 

[Alan]

Yes, in an empty column enter
=UPPER(A1) and copy down, in that column Copy > Paste Special > Values to
lose the formulas, then Cut > Paste back to the original location.
If you want to use code, see you Jimmy here,
http://www.mvps.org/dmcritchie/excel/proper.htm
Regards,

 

[Myrna Larson]

YOu can do it with formulas or with a macro. For the latter, John Walkenbach's
Power Utility Pak has this ability. Otherwise, the following macro will
operate on the cells that are selected at the time you run it.

Sub ChangeCase()
Dim Cell As Range

On Error Goto ErrTrap
For Each Cell in Selection.SpecialCells(xlCellTypeConstants, xlTextValues)
Cell.Value = UCase$(Cell.Value)
Next Cell

Done:
Exit Sub

ErrTrap:
Resume Done
End Sub