Results 1 to 4 of 4

Thread: How to make all caps in excel

  1. #1
    Join Date
    Jan 2009
    Posts
    40

    How to make all caps in excel

    Hi,
    I am using MS Office 2003 on my XP desktop. I have some data on my excel worksheet. The data is in small letters. How can i change it to capital letters. Is there all caps function like in MS word? Anyone?

    Thank you in advance.

  2. #2
    Join Date
    May 2008
    Posts
    4,574

    Re: How to make all caps in excel

    You can do it by typing the words again if the data is small. If it is a large data then have a look at Excel and capitalization to change the text in capital or uppercase.

  3. #3
    Join Date
    May 2008
    Posts
    4,348

    Re: How to make all caps in excel

    ASAP Utilities is the best add-in for excel. It has many functions like uppercase, lowercase, etc. It is easy to operate and merge several steps into one.

  4. #4
    Join Date
    May 2008
    Posts
    3,319

    Re: How to make all caps in excel

    Try this macro:
    Sub ucases()
    Dim a As Range
    addr = InputBox("type the range address, eg, A1:B10")
    Set a = Range(addr)
    For i = 1 To a.Rows.Count
    For j = 1 To a.Columns.Count
    a.Cells(i, j) = UCase(a.Cells(i, j))
    Next j
    Next i
    End Sub

Similar Threads

  1. How to make Excel VBA Read Only
    By Sayam in forum Software Development
    Replies: 7
    Last Post: 21-12-2012, 10:21 AM
  2. How to make a Schematic in Microsoft Excel
    By vALaNCiA in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 04:10 PM
  3. How to make 1 to 001 in Microsoft Excel
    By Kumar esan in forum MS Office Support
    Replies: 2
    Last Post: 01-02-2012, 06:50 PM
  4. How can I make Birthday reminder in Excel
    By Choo-Kheng in forum Windows Software
    Replies: 6
    Last Post: 10-07-2011, 11:13 AM
  5. How to make MS Excel LDAP query
    By denny walter in forum Windows Software
    Replies: 3
    Last Post: 27-11-2010, 05:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •