Formula = sheet tab name
 

Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi

Put in say, A1*:

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

(This'll extract the sheetname into A1.
But you need to save the file first)

*can be any cell in the sheet

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
cindi wrote in message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi

Cindi, try this, file must be saved first for it to work

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"cindi" wrote in message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi

Thank you! Thank you! Thank you!

Cindi
-----Original Message-----
Put in say, A1*:

=3DMID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,32)

(This'll extract the sheetname into A1.
But you need to save the file first)

*can be any cell in the sheet

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----
cindi wrote in=20
message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi


.

Thank you! Thank you! Thank you!

Cindi
-----Original Message-----
Cindi, try this, file must be saved first for it to work

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can
benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"cindi" wrote in
message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi


.

You're welcome, Cindi !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Cindi wrote in message
...
Thank you! Thank you! Thank you!

Cindi

anchor it

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


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul B" wrote in message
...
Cindi, try this, file must be saved first for it to work

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"cindi" wrote in message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi