Format cell to capital letters.

J

Jan Nielsen

Does Excel have a cell format function that changes all letters entered in a
cell to capital letters? Example: Enter "tEsT" in a cell and press enter -
Excel changes the entered text in that cell to "TEST".
Thank you.
Jan
 
F

Frank Kabel

Hi
there's no format for this but you may use the function
=PROPER(A1)
in an adjacent cell
 
N

neil

Hi Jan,

this might be useful:

Copy and paste this on to the VB editor sheet in which you want the results.

' Private sub - changing case to upper case as you type data
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("A1:A10")) Is Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Application.EnableEvents = True
End Sub

regards,

neil
 
Top