how do I convert font into all caps in Excel?

A

andalusiana

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!
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert a list from the web to a good database in Excel 3
Convert the amount into a word format 2
Countif with multiple text values in cell 3
How do I convert addresses to all caps in Office 2007? 3
Excel Convert word into numbers and back 4
How do i sort and count data into categories using a pivot table? 1
Anyone who can help my fried mind with this solution? 1
How do convert an entire column of text in Excel to all caps? 10

Top