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

Change from mixed caps and upper lower to all upper lower case 3
Making text all CAPS in excel 4
Validate data but then change the entry to upper case 4
Lower-Case Characters 2
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT 1
Caps Lock vs Lower Case 5
VBA set thick borders around non empty cells in range 0
Change all text on Spread sheet 1

Top