Find and Replace in Formulas

Options

Hello,

I use a TON of formulas that involve employee names. When creating sheets for new employees I need to paste the names into each formula. It takes FOREVER because I cannot find and replace within the formulas. Am I missing something?


Also, how do I stop this from happening? I can't make a column "number only" so I get lots of extraneous entries that skew my data.

Thank you!

Tags:

Answers