G
Guest
Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help
automatically?
Thank you for any help
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been saved
and given a name.
Biff
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been saved
and given a name.
Biff
B
Biff
Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been saved
and given a name.
Biff
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been saved
and given a name.
Biff
G
Guest
Thank you it worked perfectly!!
Biff said:Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been saved
and given a name.
Biff
LPatt said:Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help
G
Guest
Thank you it worked perfectly!!
Biff said:Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been saved
and given a name.
Biff
LPatt said:Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help
G
Guest
more than one way to skin a cat
=RIGHT(CELL("filename",IV1),LEN(CELL("filename",IV1))-FIND("]",CELL("filename",IV1),1))
the cell eference IV1 can be any cell reference,it seems to work without a
cell reference but things start to go wrong if you copy tht sheet or workbook.
It anchors that formula to that sheet.
=RIGHT(CELL("filename",IV1),LEN(CELL("filename",IV1))-FIND("]",CELL("filename",IV1),1))
the cell eference IV1 can be any cell reference,it seems to work without a
cell reference but things start to go wrong if you copy tht sheet or workbook.
It anchors that formula to that sheet.
G
Guest
more than one way to skin a cat
=RIGHT(CELL("filename",IV1),LEN(CELL("filename",IV1))-FIND("]",CELL("filename",IV1),1))
the cell eference IV1 can be any cell reference,it seems to work without a
cell reference but things start to go wrong if you copy tht sheet or workbook.
It anchors that formula to that sheet.
=RIGHT(CELL("filename",IV1),LEN(CELL("filename",IV1))-FIND("]",CELL("filename",IV1),1))
the cell eference IV1 can be any cell reference,it seems to work without a
cell reference but things start to go wrong if you copy tht sheet or workbook.
It anchors that formula to that sheet.
B
Biff
You're welcome. Thanks for the feedback!
Biff
Biff
LPatt said:Thank you it worked perfectly!!
Biff said:Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been
saved
and given a name.
Biff
LPatt said:Is there a formula to make cell A5 show the name of the tab for that
sheet
automatically?
Thank you for any help
B
Biff
You're welcome. Thanks for the feedback!
Biff
Biff
LPatt said:Thank you it worked perfectly!!
Biff said:Try this:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
The file must already exist. In other words, it must have already been
saved
and given a name.
Biff
LPatt said:Is there a formula to make cell A5 show the name of the tab for that
sheet
automatically?
Thank you for any help
D
Dave Peterson
If you leave off the range reference, the formula will return info from the
sheet that was active when excel recalculated.
Open two workbooks (each must have been saved)
put this in A1 of the first worksheet of each workbook:
=cell("Filename")
put this in A2 of the first worksheet of each workbook:
=cell("filename",a1)
and then window|arrange|horizontal
so you can see both worksheets
And force a couple of recalculations (Hit F9).
then select the other worksheet and hit F9.
Notice the difference.
Select one
sheet that was active when excel recalculated.
Open two workbooks (each must have been saved)
put this in A1 of the first worksheet of each workbook:
=cell("Filename")
put this in A2 of the first worksheet of each workbook:
=cell("filename",a1)
and then window|arrange|horizontal
so you can see both worksheets
And force a couple of recalculations (Hit F9).
then select the other worksheet and hit F9.
Notice the difference.
Select one
more than one way to skin a cat
=RIGHT(CELL("filename",IV1),LEN(CELL("filename",IV1))-FIND("]",CELL("filename",IV1),1))
the cell eference IV1 can be any cell reference,it seems to work without a
cell reference but things start to go wrong if you copy tht sheet or workbook.
It anchors that formula to that sheet.
--
paul
(e-mail address removed)
remove nospam for email addy!
LPatt said:Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help
D
Dave Peterson
If you leave off the range reference, the formula will return info from the
sheet that was active when excel recalculated.
Open two workbooks (each must have been saved)
put this in A1 of the first worksheet of each workbook:
=cell("Filename")
put this in A2 of the first worksheet of each workbook:
=cell("filename",a1)
and then window|arrange|horizontal
so you can see both worksheets
And force a couple of recalculations (Hit F9).
then select the other worksheet and hit F9.
Notice the difference.
Select one
sheet that was active when excel recalculated.
Open two workbooks (each must have been saved)
put this in A1 of the first worksheet of each workbook:
=cell("Filename")
put this in A2 of the first worksheet of each workbook:
=cell("filename",a1)
and then window|arrange|horizontal
so you can see both worksheets
And force a couple of recalculations (Hit F9).
then select the other worksheet and hit F9.
Notice the difference.
Select one
more than one way to skin a cat
=RIGHT(CELL("filename",IV1),LEN(CELL("filename",IV1))-FIND("]",CELL("filename",IV1),1))
the cell eference IV1 can be any cell reference,it seems to work without a
cell reference but things start to go wrong if you copy tht sheet or workbook.
It anchors that formula to that sheet.
--
paul
(e-mail address removed)
remove nospam for email addy!
LPatt said:Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help
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.