Posted to microsoft.public.excel.misc

external usenet poster

Posts: 49

Edit Replace formula

In Excel 2000, I have hunreds of these fomulas...

=+RFE!C74
=+WEE!C184
=+SSSS!C56
=+EDW!C1043

I want to do an edit replace to make them...

=+RFE!C74/1000
=+WEE!C184/1000
=+SSSS!C56/1000
=+EDW!C1043/1000

Can I do this using Edit-Replace?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Edit Replace formula	snax500	Excel Discussion (Misc queries)	2	November 21st 06 09:51 PM
Edit Replace	Zee	Excel Discussion (Misc queries)	1	January 5th 06 08:56 PM
edit replace	Tee	Excel Discussion (Misc queries)	6	October 31st 05 06:43 PM
Replace "insert function" with "edit formula" button in fourmula b	13brian	Excel Discussion (Misc queries)	0	August 24th 05 08:49 PM
use replace to edit a formula with wildcards	koskyil	Excel Worksheet Functions	11	August 23rd 05 06:13 PM

All times are GMT +1. The time now is 12:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us