Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for copying tap info into a cell
I know there is one, I just cannot remember what it is...I need a formula to
place the text on the tab of a worksheet into a designated cell in the same worksheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for copying tap info into a cell
=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)
-- Allllen "James" wrote: I know there is one, I just cannot remember what it is...I need a formula to place the text on the tab of a worksheet into a designated cell in the same worksheet. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for copying tap info into a cell
You need a cell reference in the formula.......any cell will do.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) See Bob Phillips' site for info on why. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 08:59:02 -0800, Allllen wrote: =MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
if and then formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |