| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab Names
Thanks for the formula. I tried to copy and paste into a cell and Excel
advised the formula contained an error, highlighting the the following portion: CELL("filename" Did I do something wrong? "JudithJubilee" wrote: Hello sdmccabe, Type the following formula: =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1) )-FIND("]",CELL"filename",A1),1)) Exactly as is written but on 1 line Judith -- Hope this helps "sdmccabe" wrote: Can I display the name of a tab in a given cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have 2 columns of names - need to filter out names not duplicated | Excel Worksheet Functions | |||
| The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
| Convert Local Names to Global Names | Excel Worksheet Functions | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
Threaded Mode
