Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Replace
In many cells, = 12 * XXX, where XXX vary for all the cells
I want to use find & replace to change cells to XXX, omitting the =12* what should I enter in the replace ? Thanks Excel 2003 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Replace
is XXX a numerica value?
if ues then replace =12 with =1 then. (just kidding..) you should put find: =12~* replace with empty "PL" wrote: In many cells, = 12 * XXX, where XXX vary for all the cells I want to use find & replace to change cells to XXX, omitting the =12* what should I enter in the replace ? Thanks Excel 2003 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Replace
I am assuming that XXX represents numbers...
Removing =12* from the formula is same as dividing the values by 12... If this is true then enter 12 in any empty cell, copy the cell, select the cells (I am assuming that you can do this without much difficulty) with the formula, choose PASTE SPECIAL and choose Divide and then click OK. "PL" wrote: In many cells, = 12 * XXX, where XXX vary for all the cells I want to use find & replace to change cells to XXX, omitting the =12* what should I enter in the replace ? Thanks Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Find and replace results can the appearance of find be different? | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions |