Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula = sheet tab name
Can I create a formula in a cell that will equal the
sheet tab name? Thanks, Cindi |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 . |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Need help to set-up a formula on Excel work sheet? | New Users to Excel | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
what is the formula for changing the same cell on different sheet. | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |