View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jimswinder jimswinder is offline
external usenet poster
 
Posts: 32
Default replacing text within a formula

What if I don't want to replace it? Guess I should have been more clear. Is
there a way to create a new formula where "Feb" is replaced by "Mar"? I have
over 105 cells with formulas that I need to replace the month with the rest
of the months of the year. ie: I need to replicate =Jan!$G37 with =Feb!$G37
and =Mar!$G37 and =Apr!$G37 etc. I figured this would be easier than trying
to do a "Paste Link" of all 1272 differnt formulas.

"Gary''s Student" wrote:

Used Edit Find and then Replace
--
Gary's Student
gsnu200702


"jimswinder" wrote:

is it possible? ie: I want to replace "Feb" with "Mar" in the following
formula:
=Feb!$G37. Even if I had to do it within a different cell, that would be
fine.