EXCEL Capital Letters

P

Peo Sjoblom

You would need a macro for that to be simple


Sub Upper_Case()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim Cell as Range
On Error Resume Next
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Formula = UCase(Cell.Formula)
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub

there is also a function called UPPER that will convert all letters to upper
case

to install macros see

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom
 

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

how to change small letters to capital letters 4
conditional formatting - highlight Capital letters but not lower c 2
How do I change All Capitals Text to normal Text 1
Changing grey column headings from numbers back to capital letters 2
Capping Letters in EXCEL 1
changing capslock letters into normal letters 4
how do i turn all letters into capital letters? 3
HOW TO COUNT CAPITAL LETTERS IN DATA? 1

Top