Use of Worksheet name

P

Patch

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.
 
P

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
 
G

Gary''s Student

Once the file has been saved at least once:

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

Patch

Perfect, thanks Poe

Peo Sjoblom said:
="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 said:
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.
Click to expand...
Click to expand...
 
Top