| 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 | |||
Hybrid Mode
