+ Reply to Thread
Results 1 to 3 of 3

repetitive changes in a link

Hybrid View

  1. #1
    Registered User
    Join Date
    07-14-2009
    Location
    Metairie, La
    MS-Off Ver
    Excel 2003
    Posts
    2

    repetitive changes in a link

    I have an excel spreadsheet that has many cells with formulas (Links) in each cell like this:
    ='[2009 LaBranchGoalsbyBranch.xls]ORM'!$G$122
    ='[2009 LaBranchGoalsbyBranch.xls]MRD'!$G$108
    ='[2009 LaBranchGoalsbyBranch.xls]HAM'!$G$108

    there are hundreds of cells that repeat the same info, I want to be able to highlight a group of cells & just change 1 character in each cell, for instant, I will change the G to and F:
    ='[2009 LaBranchGoalsbyBranch.xls]ORM'!$F$122
    ='[2009 LaBranchGoalsbyBranch.xls]MRD'!$F$108
    ='[2009 LaBranchGoalsbyBranch.xls]HAM'!$F$108

    Is there a way to do this without clicking into each cell?

    Thanks
    Denise

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: repetitive changes in a link

    Select the entire range of cells you want to change then use the Find and replace (all) feature built into Excel.

    Find = $G

    Replace with = $F

  3. #3
    Registered User
    Join Date
    07-14-2009
    Location
    Metairie, La
    MS-Off Ver
    Excel 2003
    Posts
    2

    Thumbs up Re: repetitive changes in a link

    Thank you so much. This will save me quite a bit of time at the end of each quarter.

    Denise

+ 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