Posted to microsoft.public.excel.worksheet.functions

rob_t

external usenet poster

Posts: 1

how do I repeatedly substitute a value in a formula

I have a spreadsheet with date references repeatedly used in the formula. I
wish to change the formula from 07 to 08 and not have to manually change in
every cell it appears

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
SUBSTITUTE formula -- variable spacing between parameters??	The Moose	Excel Worksheet Functions	6	December 2nd 06 07:00 PM
Concatonate and Substitute show the formula rather than the result	Pingu_3D	Excel Worksheet Functions	2	December 1st 06 02:27 PM
Nesting the SUBSTITUTE formula	Marco Margaritelli	Excel Worksheet Functions	4	February 25th 06 02:50 PM
Substitute Formula	AmyD	Excel Worksheet Functions	2	January 5th 06 01:36 PM
Excel Crashes Repeatedly	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	4	May 31st 05 01:39 AM

All times are GMT +1. The time now is 05:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us