Format cell to capital letters.

Discussion in 'Microsoft Excel Misc' started by Guest, Oct 4, 2004.

  1. Guest

    Guest 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
     
    Guest, Oct 4, 2004
    #1
    1. Advertisements

  2. Guest

    Frank Kabel Guest

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

    --
    Regards
    Frank Kabel
    Frankfurt, Germany


    Jan Nielsen wrote:
    > 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
     
    Frank Kabel, Oct 4, 2004
    #2
    1. Advertisements

  3. Guest

    Guest 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

    "Jan Nielsen" wrote:

    > 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
     
    Guest, Oct 4, 2004
    #3
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Format Cells to Capital Letters

    Guest, May 1, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    407
    Gord Dibben
    May 1, 2004
  2. Guest

    display months (in date format) in capital letters

    Guest, Mar 8, 2007, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    2,616
    Roger Govier
    Mar 8, 2007
  3. Guest

    how do i turn all letters into capital letters?

    Guest, May 11, 2007, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    827
    David McRitchie
    May 11, 2007
  4. Guest

    how to change small letters to capital letters

    Guest, May 28, 2007, in forum: Microsoft Excel Misc
    Replies:
    4
    Views:
    2,618
    Roger Govier
    May 30, 2007
  5. DuncanM9
    Replies:
    1
    Views:
    1,676
    Mike H
    Nov 19, 2008
Loading...

Share This Page