Tab Names

J

JudithJubilee

Hello sdmccabe,

Type the following formula:

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

Exactly as is written but on 1 line

Judith
 
S

sdmccabe

Thanks for the formula. I tried to copy and paste into a cell and Excel
advised the formula contained an error, highlighting the the following
portion:

CELL("filename"

Did I do something wrong?


JudithJubilee said:
Hello sdmccabe,

Type the following formula:

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

Exactly as is written but on 1 line

Judith
--
Hope this helps


sdmccabe said:
Can I display the name of a tab in a given cell?
Click to expand...
Click to expand...
 
I

intruder9

Try this =MID(CELL("filename"), FIND("]",CELL("filename"))+1,
LEN(CELL("filename"))-FIND("]", CELL("filename")))
 
P

Peo Sjoblom

That won't work, do as follows


1. Enter the formula in a cell on Sheet1

2. enter the same formula in Sheet2

3. Go back to Sheet1, it now says Sheet2

you need to add a cell reference

=MID(CELL("filename",A1),
FIND("]",CELL("filename",A1))+1,LEN(CELL("filename".A1))-FIND("]",
CELL("filename",A1)))

also this part

LEN(CELL("filename"))-FIND("]", CELL("filename")))

is really obsolete, since a sheet name can only contain 31 characters you
can use

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