Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to make all caps in excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 12-06-2009
Member
 
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.

Reply With Quote
  #2  
Old 12-06-2009
Member
 
Join Date: May 2008
Posts: 4,562
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.
Reply With Quote
  #3  
Old 12-06-2009
Member
 
Join Date: May 2008
Posts: 4,343
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.
Reply With Quote
  #4  
Old 12-06-2009
Member
 
Join Date: May 2008
Posts: 3,313
Re: How to make all caps in excel

Try this macro:
Quote:
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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to make all caps in excel"
Thread Thread Starter Forum Replies Last Post
How to make Excel VBA Read Only Sayam Software Development 7 21-12-2012 10:21 AM
How to make a Schematic in Microsoft Excel vALaNCiA MS Office Support 2 03-02-2012 04:10 PM
How to make 1 to 001 in Microsoft Excel Kumar esan MS Office Support 2 01-02-2012 06:50 PM
How can I make Birthday reminder in Excel Choo-Kheng Windows Software 6 10-07-2011 11:13 AM
How to make MS Excel LDAP query denny walter Windows Software 3 27-11-2010 05:01 AM


All times are GMT +5.5. The time now is 10:39 AM.