| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the PROPER/LOWER/UPPER commands
Let's say your data in Column A2:A5000
In B2 =PROPER(A2) Copy down to B5000 "Mickoloney" wrote: Hello. Please help me format the entire column with more than 5,000 records using the PROPER command. From the Offline and Online Help, it only shows formatting of a text in only one cell after the other. But I have tons of records to format! Need your help! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the PROPER/LOWER/UPPER commands | Excel Discussion (Misc queries) | |||
| Using the PROPER/LOWER/UPPER commands | Excel Discussion (Misc queries) | |||
| excel 2007 customize quick access toolsbar adding menus commands | Excel Discussion (Misc queries) | |||
| How do I get the quick key commands to work in excel? | Excel Worksheet Functions | |||
| My cut, copy and paste commands are not working when I right clic. | Excel Discussion (Misc queries) | |||
Linear Mode
