Prev: Round formula
Next: Sorting in Excel
From: antonioejones612 on 1 Apr 2010 10:23
I would like to know how to change a range of cells from mixed- or lower-case
to all upper-case in Excel.
From: Eduardo on 1 Apr 2010 10:31
Hi,
in another column enter

=upper(A1)

I assume that A1 is the cell where you have the text, copy formula down


"antonioejones612" wrote:

> I would like to know how to change a range of cells from mixed- or lower-case
> to all upper-case in Excel.
From: Gord Dibben on 1 Apr 2010 11:22
By formula............see UPPER function in help

By macro..............

Sub Upper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 07:23:02 -0700, antonioejones612
<antonioejones612(a)discussions.microsoft.com> wrote:

>I would like to know how to change a range of cells from mixed- or lower-case
>to all upper-case in Excel.

 | 
Pages: 1
Prev: Round formula
Next: Sorting in Excel