Converting small letters to caps

[ahmedmirza]

This is possible in word.. but how can we convert small letters into caps in excel.. ?

 

[repairman615]

I beleive that would be the =UPPER() function.

Say cell a1 has your text.

=UPPER(A1)

 

[ogo]

I think this will be useful ,http://www.castlejb.com/webdesign/excelupper/exceltextfunction.html

Or if u need a macro,

Sub MyUpperCase()
    
    Application.ScreenUpdating = False
    Dim cell As Range
    For Each cell In Range("$A$1:" & Range("$A$1").SpecialCells(xlLastCell).Address)
        If Len(cell) > 0 Then cell = UCase(cell)
    Next cell
    
    Application.ScreenUpdating = True
    
End Sub

 

[ahmedmirza]

Guys... Thanks a lot...