Method to Capitalize Existing Data

[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

 

[akphidelt]

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

=UPPER(A1)

Then copy and drag that down

 

[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