Find and Replace in a Formula

[purook02]

I have 1227 various formulas in an excel spreadsheet that at some point in them have roundup(""),0).

Now I need to change every single one of these to be ceiling(""),25)

is there a way to do this with the find and replace function?

Thanks,

Dan

 

[Roderick_E]

I have 1227 various formulas in an excel spreadsheet that at some point in them have roundup(""),0).

Now I need to change every single one of these to be ceiling(""),25)

is there a way to do this with the find and replace function?

Thanks,

Dan

Hold down control and tilde ~
Will show formulas.

Control F, replace all

Hold down control and tilde ~ to hide formulas back