Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace ROUNDUP(stuff, 0)
I have several hundred cells with =ROUNDUP(formulas, 0). I want to
erase the ROUNDUP( ,0), but don't know how to use find and replace on this. I can't do it in two steps, because then Excel doesn't like the resulting formula after deleting either ROUNDUP( or ,0). Is there a simple way to turn off formulas? Or another way around this problem? Earl |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace ROUNDUP(stuff, 0)
Copy the range, paste special, values.
Dave -- Brevity is the soul of wit. " wrote: I have several hundred cells with =ROUNDUP(formulas, 0). I want to erase the ROUNDUP( ,0), but don't know how to use find and replace on this. I can't do it in two steps, because then Excel doesn't like the resulting formula after deleting either ROUNDUP( or ,0). Is there a simple way to turn off formulas? Or another way around this problem? Earl |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace ROUNDUP(stuff, 0)
Unfortunately, I need to keep the formulas inside of the ROUNDUP
function. I just need to delete "ROUNDUP(" and ",0)". Thanks, Earl On Oct 25, 11:56 am, Dave F wrote: Copy the range, paste special, values. Dave -- Brevity is the soul of wit. " wrote: I have several hundred cells with =ROUNDUP(formulas, 0). I want to erase the ROUNDUP( ,0), but don't know how to use find and replace on this. I can't do it in two steps, because then Excel doesn't like the resulting formula after deleting either ROUNDUP( or ,0). Is there a simple way to turn off formulas? Or another way around this problem? Earl |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and Replace ROUNDUP(stuff, 0)
Sorry I misunderstood your question.
One possible way: 1) Create a UDF, getformulaI which returns the formula in a cell. 2) Format the returned formulas as text 3) Run the MID function to extract from the text string the formula you want 4) Convert the text string to a formula. Code for the UDF is: Function GetFormulaI(Cell As Range) As String 'Application.Volatile = True If VarType(Cell) = 8 And Not Cell.HasFormula Then GetFormulaI = "'" & Cell.Formula Else GetFormulaI = Cell.Formula End If If Cell.HasArray Then _ GetFormulaI = "{" & Cell.Formula & "}" End Function This is rather awkward tho. There may be a different way -- Brevity is the soul of wit. " wrote: Unfortunately, I need to keep the formulas inside of the ROUNDUP function. I just need to delete "ROUNDUP(" and ",0)". Thanks, Earl On Oct 25, 11:56 am, Dave F wrote: Copy the range, paste special, values. Dave -- Brevity is the soul of wit. " wrote: I have several hundred cells with =ROUNDUP(formulas, 0). I want to erase the ROUNDUP( ,0), but don't know how to use find and replace on this. I can't do it in two steps, because then Excel doesn't like the resulting formula after deleting either ROUNDUP( or ,0). Is there a simple way to turn off formulas? Or another way around this problem? Earl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |