sheet name

D

Daryl

I'm looking for a formula that will produce the sheet name (only) within the sheet the formula resides. Could somone please help me
Thank You
Daryl
 
H

Harald Staff

Hi Daryl

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

Note that it won't work until the file is saved (= has a file path and file
name)

HTH. Best wishes Harald

Daryl said:
I'm looking for a formula that will produce the sheet name (only) within
Click to expand...
the sheet the formula resides. Could somone please help me?
 
F

Frank Kabel

Hi
one way:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("filename"
,A1),1))
-----Original Message-----
I'm looking for a formula that will produce the sheet
Click to expand...
name (only) within the sheet the formula resides. Could
somone please help me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Using a vlookup to search multiple criteria for one result? 7
how to copy and paste value from one sheet to another 4
trouble with (complicated) vlookup searching another workbook 2
Lookup or search using the * character 1
Mail Merge Directory Conditional Page Break 0
comparing sheet to sheet and adding value 1
Excel formula help for calculating freight. 2

Top