Method to Capitalize Existing Data

  • Thread starter Thread starter JerryS
  • Start date Start date
J

JerryS

We have a column of addresses that needs to be in all caps for import into
another application. We don't want to retype the list. Any suggestions
 
Suppose the address is in A1. In another column, say B1... type in

=UPPER(A1)

Then copy and drag that down
 
Did you want to change them permanently? If so, you could use this macro...

Sub Capitalize()
Dim C As Range
For Each C In Range("A1:A1000")
C.Value = UCase(C.Value)
Next
End Sub

Simply change the address range to cover the cells you want this to apply
to.

Rick
 
Back
Top