How to make all caps in excel

[Drogbaa]

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.

[Glenny]

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.

[JonathanD]

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.

[Raine]

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