Running multiple formulas at once

[Moragtao]

I have an odd question for you all. My co-worker currently has a table loaded where multiple cells in varying rows and columns have formulas in them stored as text. He's wondering if there's a way to, rather than go into each cell with a text formula manually, have excel run them all at once?

The attached sheet is very small example. Please let me know if I need to elaborate further, as it's getting to be the end of my day here and I'm losing the ability to think clearly!

[FlameRetired]

Yes. It happens now and again and I don't know why.

Try highlighting / selecting the offending range (A2:B7). Activate Find and Replace (Ctrl + H).
Believe it or not

1. Find: =
2. Replace with: =
3. Replace all

Apparently Excel has to be 'bumped' to be reminded those are formulas.

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted value may be altered to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[Moragtao]

You all are fantastic! This works perfectly, thank you so very much!

[FlameRetired]

You are welcome. Thank you for the feedback, added rep and marking your thread Solved.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M