How do I convert addresses to all caps in Office 2007?

  • Thread starter Thread starter cmm-retired once
  • Start date Start date
C

cmm-retired once

For the post office, bulk mail addresses are to be in caps. Date is entered
upper and lower case. For first class mail, we do not want to use all caps.
Can I convert the upper/lower case addresses to all upper case?
 
--Suppose your data is in Sheet1
--In Sheet2 cell A1 enter the formula
=UPPER(Sheet1!A1)
--Copy the formula down and across...and once done Copy>PasteSpecial>Values
to convert all formula cells to values..

If this post helps click Yes
 
Without all those messy formulas and clean up after.

Sub Upper()
Dim Cell As Range
Dim rng As Range
Application.ScreenUpdating = False
Set rng = Intersect(Selection, _
Selection.SpecialCells(xlCellTypeConstants))
For Each Cell In rng
Cell.Formula = UCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

On Wed, 2 Sep 2009 12:19:03 -0700, cmm-retired once <cmm-retired
 
Back
Top