how do I convert font into all caps in Excel?

  • Thread starter Thread starter andalusiana
  • Start date Start date
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!
 
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

pull data from one table to another if multiple conditions are met 3
Text to Columns 1
Columns 2
How to convert a list from the web to a good database in Excel 3
Can't get bar code font to work in EXCEL 2003 3
Convert the amount into a word format 2
help! 7
How do i sort and count data into categories using a pivot table? 1

Back
Top