Auto-Format Capitalizing
 

I want one column in my spreadsheet to ALWAYS be capitalized. Surely there
is a simple way to do this. Does anyone know of one?

Auto-Format Capitalizing
 

It is surely not. You can do it with VBA though. Put this in the worksheet
module:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cel As Range
For Each cel In Target
If cel.Column = 2 Then
If cel.Formula < UCase$(cel.Formula) Then _
cel.Formula = UCase$(cel.Formula)
End If
Next
End Sub

HTH. Best wishes Harald

"Meesheltx" skrev i melding
...
I want one column in my spreadsheet to ALWAYS be capitalized. Surely
there
is a simple way to do this. Does anyone know of one?