changing case

  • Thread starter Thread starter Sheetal
  • Start date Start date
S

Sheetal

Hi, is there any way I can change the letter case in Excel. I know thi
can be done in word by going to format and change case, but am unsur
how to do it in EXcel.

I simply want to change everything to capital letters.

Please let me know, thank you very much for your help.

Sheeta
 
Hi Sheetal

There is a function =UPPER(A1) but if you want to change all the cells
then use a macro

See this webpages

http://www.mvps.org/dmcritchie/excel/proper.htm
Or
http://www.cpearson.com/excel/case.htm

Here is a Macro for changing text cells in the selection

Sub Uppercase_macro()
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selectie Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each cel In selectie
cel.Value = UCase(cel.Value)
Next cel
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
 
thanks so much for that - I have copied it into my spreadsheet, and it
works fine.

Cheers!
 
Back
Top