Once the file has been saved at least once:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Gary''s Student - gsnu200752


"Patch" wrote:

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.