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
Bookmarks