| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Displaying in a cell the formula from another cell
Hi,
is it possible to show (in text) the formula from the cell next to it? For example, in cell A1 I have the formula ='D:My Documents\[test.xls]Sheet1'!D18 which gives as result "18". Can I display in cell A2 the text "D:My Documents\[test.xls]Sheet1'!D18" somehow? Arjan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Conditional Formatting for dates | Excel Worksheet Functions | |||
Threaded Mode
