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.
Printable View
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.
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 http://forums.techarena.in/windows-software/1124094.htm to change the text in capital or uppercase.
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.
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