| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
beginner question re =PROPER(A1) command
I have a list of names and addresses in columns and have used the
=PROPER(A1) command to change the allcaps columns to be correctly capitalised words . Question is how can I just remove the columns which are allcaps and just be left with the correctly capitalised ones? Using the formula above, of course I cannot delete them as the formula is dependant on the existence of the original. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Question from a beginner | Excel Discussion (Misc queries) | |||
| Beginner Question | Charts and Charting in Excel | |||
| Beginner question! | Excel Discussion (Misc queries) | |||
| Beginner question | Excel Discussion (Misc queries) | |||
| how do i use the proper command | Excel Worksheet Functions | |||
Threaded Mode
