One way:

=REPLACE(CELL("filename",A1),1,FIND("]",CELL
("filename",A1)),"")

Note: wb must saved for this to work.

HTH
Jason
Atlanta, GA

-----Original Message-----
wanting to set up some excel templates - can i insert
the name of the
worksheet into a field so that I don't have to rename
every tab plus every
field each time I use the template
.