Method to Capitalize Existing Data
 

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
--
JerryS

Method to Capitalize Existing Data
 

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

=UPPER(A1)

Then copy and drag that down

"JerryS" wrote:

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
--
JerryS

Method to Capitalize Existing Data
 

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


"JerryS" wrote in message
...
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
--
JerryS