Upper case format for Excel 1

[jcwoods]

Word has the formatting option of changing text to upper case, but I cannot locate that feature in Excel. Is there a keyboard command to convert existing text within a spreadsheet to upper case? (Of course, with existing text, the cap-lock feature will not work.)

 

[SonGoku]

Use the UPPER() function.
=UPPER(<cell to convert>)

Cheers!

Marcos.

 

[RacerGirl117]

I just tried this and it didn't work for me. It told me I was making a circular reference. Where are you suppose to put it?

Thank You, Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA

 

[mudstuffin]

If you put =UCase(a1) in cell a2, then the text from a1 will be in a2, converted to upper case.

This may not be what you are looking for though.

I've quickly knocked up this macro, which you could assign a shortcut key to.

Insert a module in to your workbook, and copy this to it:-


Sub ConvertToUpperCase()

For Each c In ActiveSheet.UsedRange.Cells
If c.Value <> UCase(c) Then c.Value = UCase(c)
Next c

End Sub


That should do the trick.

Regards,



Greg

 

[PeterMoran]

Hi,

Here is CaseChanger, which I use, which rotates between Upper, Proper, and Lower case. I have it on my Macros menu which I added to the Main Menu.

Sub CaseChanger()
'Step Through Case Changes
'Note: Including Static below will mean macro holds value
' Static Sub CaseChanger()
ShiftCase = ShiftCase + 1
If ShiftCase > 3 Then ShiftCase = 1
For Each Item In Selection
Select Case ShiftCase
Case 1
Item.Value = LCase(Item.Value)
Case 2
Item.Value = UCase(Item.Value)
Case 3
Item.Formula = Application.Proper(Item)
End Select
Next Item
End Sub

Hope this helps and Good Luck!

Peter Moran