| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing half a formula
I have a rows of formulas of 150 lines
ex: =Takeoff!B6*D7 =Takeoff!B54*D8 =Takeoff!B102*D9 I need to take off the *D7,*D8,etc is there a formula I can put in the find and replace to do this easier than going to each cell and deleting it. Or is there another way using Text replace item? Thanks david |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replacing text within a formula | Excel Worksheet Functions | |||
| AFTER REPLACING FORMULA WITH VALUES, HOW DO I ADD THE COLUMN? | Excel Discussion (Misc queries) | |||
| Replacing letters for figures in formula | Excel Discussion (Misc queries) | |||
| Replacing Values in Cells Via Formula | Excel Worksheet Functions | |||
| Using formula one half of answers are wrong. I have checked my dat | Excel Worksheet Functions | |||
Threaded Mode
