| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I go about finding and removing labels in formulas?
Hi. Since labels in formulas are no longer supported in 2007, how do I go
about finding and removing them? Also, as I understand it, Named Ranges are supported in 2007 so they are ok to leave in. Is this correct? -- Thanks. Chuck M. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I go about finding and removing labels in formulas?
"Chuck M" wrote...
Hi. Since labels in formulas are no longer supported in 2007, how do I go about finding and removing them? Also, as I understand it, Named Ranges are supported in 2007 so they are ok to leave in. Is this correct? Defined name functionality hasn't changed. Labels were never defined names. Excel 2007 automatically converts labels in formulas to their corresponding ranges when opening .XLS files. You shouldn't need to convert labels yourself. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding info of one column and removing it from another | Excel Discussion (Misc queries) | |||
| Finding/Removing Duplicate Numbers In A Column ? | New Users to Excel | |||
| Removing labels and names in formulas | Excel Discussion (Misc queries) | |||
| Finding/removing duplicate names in a worksheet | Excel Worksheet Functions | |||
| What Excel Formula = finding dup records and removing them? | Excel Worksheet Functions | |||
Linear Mode
