| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
use replace to edit a formula with wildcards
I have the following formula:
='Grant Project 1'!J314 but it's repeated in a column, each time with a different number (i.e. ='Grant Project 1'!J314, ='Grant Project 1'!J317, ='Grant Project 1'!J320...) and I want to replace each occurance with ='Grant Project 1'!J$314 Is there a way to use the replace tool to insert the '$' by using wildcards in place of the numbers? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Replace using wildcards | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Threaded Mode
