Method to Capitalize Existing Data

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
 
A

akphidelt

Suppose the address is in A1. In another column, say B1... type in

=UPPER(A1)

Then copy and drag that down
 
R

Rick Rothstein \(MVP - VB\)

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
 
Top