Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you Find and Replace values with in a formula?
Is it possible to search and replace values within a formula? I realize it
is easy to due to a value in a cell, but I am unable to perform this with the formulas with in the cells. |
#2
|
|||
|
|||
Edit Replace..........works fine for me on regular text or formulas in
XL2k...........what version Excel are you having trouble with? Vaya con Dios, Chuck, CABGx3 "rascall" wrote in message ... Is it possible to search and replace values within a formula? I realize it is easy to due to a value in a cell, but I am unable to perform this with the formulas with in the cells. |
#3
|
|||
|
|||
rascall,
There's a suggestion about using numbers in formulas. Read "Numbers in a formula" in http://www.smokeylake.com/excel/excel_truths.htm. Worth a read. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "rascall" wrote in message ... Is it possible to search and replace values within a formula? I realize it is easy to due to a value in a cell, but I am unable to perform this with the formulas with in the cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace | Excel Discussion (Misc queries) | |||
How do I find and replace "values" (like #N/A) in a worksheet? | Excel Discussion (Misc queries) | |||
Find and Replace Formula Links | Excel Worksheet Functions | |||
Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
VB Find and Replace | Excel Worksheet Functions |