| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of Worksheet name
Perfect, thanks Poe
"Peo Sjoblom" wrote: ="London "&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) note that your workbook need to be saved, it won't work if you just open a new workbook and use it -- Regards, Peo Sjoblom "Patch" wrote in message ... How is it possible to use a worksheet name within a cell? For example if the worksheet is called 'Nov 2007' I would like to be able to use that within cells to have text like 'London Nov 2007' or 'John - Nov 2007'. What formula can be used if any? Many Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
