Hello thalia
Not sure about what you want:
How do I enter capital letters?
- Activate CapsLock Key
How do I convert all string values already entered?
- Use a macro:
Sub ChangeIntoCaps()
Dim rg As Range
For Each rg In Range("A1:B10")
If Application.WorksheetFunction.IsText(rg) Then
rg.Value = UCase(rg)
End If
End Sub
HTH
Cordially
Pascal
"thalia" a écrit dans le message de news:
...
Please help me to turn normal letters into CAPITALS automatically, in an
excel sheet. Thank you very much!