+ Reply to Thread
Results 1 to 2 of 2

Find and Replace within Formulas

  1. #1
    Registered User
    Join Date
    08-18-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    23

    Find and Replace within Formulas

    I have several formulas which i realize have a bad cell reference in them now. Is there any way to select a range of cells and then "Find and replace" that cell reference within the function?

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Find and Replace within Formulas

    Hi Adam,

    You should be able to select the cells, open the Find/Replace dialog and then click on the Options button to expand the dialog window. Make sure the 'LookIn' drop-down box is set to formulas.

    You can then replace something like $F$7 with another cell reference, e.g. C5, G$8, etc.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1