| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel'03 how to convert a column from upper case to proper case
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel'03 how to convert a column from upper case to proper case
Assume data in Col A. Use Col B as a helper Column, then use = PROPER(A2)
and copy down. Copy Col B and paste special as values over Col A. You can now delete Col B. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "sharie palmer" <sharie palmer @discussions.microsoft.com wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "1235" appears as "One thousand two hundred thirty five" | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Loop for VBA code? | Excel Worksheet Functions | |||
| How to .. | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Hybrid Mode
