Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find and replace units of a formula
hopefully this is simple. I often want to preform a find and replace
sections of a formula, say I want to change the reference column form A to D or something.. currently I have hundreds of formulas that are sum(G11:AD11) and I'm trying to find and replace the :AD with :M, but when I perform this function, I get a message that it is not finding anything. I swear I did this exact same thing on a worksheet yesterday and it work like a charm. what am I doing wrong? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace Formula | Excel Discussion (Misc queries) | |||
Find Replace Formula | Excel Discussion (Misc queries) | |||
Find Replace Formula | Excel Discussion (Misc queries) | |||
How to find & replace a formula sequence with * in it? | Excel Discussion (Misc queries) | |||
Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) |