| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
is there a comand to return the mane of a worksheet inside a cell
Trying to find a command that returns a worksheet name inside a cell
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
is there a comand to return the mane of a worksheet inside a cell
Hi Fabian
Try this, =MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1) This one will give you the full path: =CELL("filename") HTH John "Fabian" wrote in message ... Trying to find a command that returns a worksheet name inside a cell |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
is there a comand to return the mane of a worksheet inside a cell
Hi,
=MID(CELL("filename",C1),FIND("]",CELL("filename",C1))+1,255) "Fabian" wrote: Trying to find a command that returns a worksheet name inside a cell |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
is there a comand to return the mane of a worksheet inside a cell
Ooops
The worksheet name not workbook, reading to fast. Eduardo has the answer, now you have it all. John "John" wrote in message ... Hi Fabian Try this, =MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1) This one will give you the full path: =CELL("filename") HTH John "Fabian" wrote in message ... Trying to find a command that returns a worksheet name inside a cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a Hard Return inside a cell? | Excel Discussion (Misc queries) | |||
| Can you use HLOOKUP inside VLOOKUP to tell it what column 2 return | Excel Worksheet Functions | |||
| copying worksheets to mane one document. | New Users to Excel | |||
| Why does not Excel 2003 Replace comand romove spaces from cell contents? | Excel Worksheet Functions | |||
| using the name of a worksheet written in a cell, inside a formula | Excel Worksheet Functions | |||
Linear Mode
