| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please post this thread a correct full method, method about | New Users to Excel | |||
| Please post this thread a complete correct method, method about te | New Users to Excel | |||
| How to i capitalize all words in an existing worksheet? | Excel Discussion (Misc queries) | |||
| Best method to retrieve table data | Excel Worksheet Functions | |||
| Method to increment value in data field? | Excel Discussion (Misc queries) | |||
Linear Mode
