="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.