I am trying to make state abbreviations (ex. co, ny, ca) into all capitals
(ex. CO, NY, CA). I know how to do this in word, but couldn't find anywhere
to convert in excel. Any suggestions would be appreciated!

You can use a help column, assume they start in A2 going down


In B2 put


=UPPER(A2)


copy down


then copy and paste special and select values over the old entries and
finally delete the help column


or you can put this macro in your personal.xls workbook and
attach it to a button or a shortcut, then select all the data and run the
macro


Sub Upper_Case()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim Cell As Range
On Error Resume Next
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Formula = UCase(Cell.Formula)
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub



http://www.mvps.org/dmcritchie/excel/install.htm

instruction on how to install macros

--


Regards,


Peo Sjoblom

"andalusiana" wrote in message
...
I am trying to make state abbreviations (ex. co, ny, ca) into all capitals
(ex. CO, NY, CA). I know how to do this in word, but couldn't find
anywhere
to convert in excel. Any suggestions would be appreciated!

UPPER
--
David Biddulph

"andalusiana" wrote in message
...
I am trying to make state abbreviations (ex. co, ny, ca) into all capitals
(ex. CO, NY, CA). I know how to do this in word, but couldn't find
anywhere
to convert in excel. Any suggestions would be appreciated!