in another column enter
I assume that A1 is the cell where you have the text, copy formula down
> I would like to know how to change a range of cells from mixed- or lower-case
> to all upper-case in Excel.
By formula............see UPPER function in help
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Application.ScreenUpdating = True
Gord Dibben MS Excel MVP
On Thu, 1 Apr 2010 07:23:02 -0700, antonioejones612
>I would like to know how to change a range of cells from mixed- or lower-case
>to all upper-case in Excel.