| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Lowercase or Proper to ALL CAPS
How do I change all lowercase or Proper formatted cells to ALL CAPS?
Don |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Lowercase or Proper to ALL CAPS
Dim cell as Range
for each cell in selection.SpecialCells(xlConstants,xlTextValues) cell.Value = Ucase(cell.value) Next would be the basic approach. -- Regards, Tom Ogilvy "Don" wrote in message ... How do I change all lowercase or Proper formatted cells to ALL CAPS? Don |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Lowercase or Proper to ALL CAPS
Thanks Tom........and if needing to change it to "Proper"?
Don "Tom Ogilvy" wrote in message ... Dim cell as Range for each cell in selection.SpecialCells(xlConstants,xlTextValues) cell.Value = Ucase(cell.value) Next would be the basic approach. -- Regards, Tom Ogilvy "Don" wrote in message ... How do I change all lowercase or Proper formatted cells to ALL CAPS? Don |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Lowercase or Proper to ALL CAPS
Don,
Try cell.Value = StrConv(cell.Value, vbProperCase) -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com (email address is on the web site) "Don" wrote in message ... Thanks Tom........and if needing to change it to "Proper"? Don "Tom Ogilvy" wrote in message ... Dim cell as Range for each cell in selection.SpecialCells(xlConstants,xlTextValues) cell.Value = Ucase(cell.value) Next would be the basic approach. -- Regards, Tom Ogilvy "Don" wrote in message ... How do I change all lowercase or Proper formatted cells to ALL CAPS? Don |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change date that is in All Caps to proper format? | Excel Worksheet Functions | |||
| How do I change from all caps to proper case? | Excel Discussion (Misc queries) | |||
| Is there a way to change Lowercase or Proper to ALL CAPS? | Excel Worksheet Functions | |||
| How do I change the case from all caps to proper for names I have in columns E, F, G? | Excel Discussion (Misc queries) | |||
| How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) | |||
Hybrid Mode
