Formula needed

[agoodson56]

How can I create a formule that will refect a worksheet title?

 

[schielrn]

You can try:

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

Hope that helps.

 

[Scott Huish]

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

 

[agoodson56]

How would I make a formula that would show the tab name

 

[schielrn]

That formula should show the tab name? Make sure you have saved the workbook for the formula to work.

 

[Jonmo1]

I think the OP may have confused
Worksheet title and SHEET Name...

WorkBOOK title = Bookname.xls
WorkSHEET title = Tab Name

For WorkSHEET title - use formulas provided previously...

for WorkBOOK Title, (i'm sure there's something easier than this...)
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

 

[Scott Huish]

The workbook does need to be saved first in order for these formulas to work. Save the workbook and then hit F9