Format cell to capital letters.

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top