In Excel, changing a range of cells to all caps.

  • Thread starter antonioejones612
  • Start date
A

antonioejones612

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

Eduardo

Hi,
in another column enter

=upper(A1)

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word doc keeps changing to ALL CAPS 0
Dealing with the error: unable to filter on excel hc home school 0
Cumulative formula for word table 0
Range headings 0
Fill tringle in a cell with color 1
Lower-Case Characters 2
Dates In Excel 5
Section and Page numbering 0

Top