| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to get the formula in one cell as text into another cell.
Ineed to copy the formula (reference to a cell in another spreadsheet) as
text into another cell and use the reference as a offset point. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to get the formula in one cell as text into another cell.
It seems as if you want to copy a formula in one cell to another cell, but as
text? Select the cell containing the formula. Block the text in the formula bar, press <Ctrl<C. Now go to the cell where you want it to appear as text. In the formula bar, enter an apostrophe "'", and then press <CtrL<V. Not at all clear what you further want though! -- Hth Kassie Kasselman "odd" wrote: Ineed to copy the formula (reference to a cell in another spreadsheet) as text into another cell and use the reference as a offset point. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
