Use of Worksheet name

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Guest]

Once the file has been saved at least once:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

 

[Guest]

Perfect, thanks Poe

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

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.