replacing text within a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
duh...I guess I could copy and paste a whole new column of what I want to
replace, then copy and paste that where I need it.

Thanks for your help..it worked.
 
Hi

You could use Indirect and have the Sheet name held in another cell

=INDIRECT($A$1&"!$G37")
Change A1 from Jan to Feb to Mar etc.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drag formula down from columns that go acros 3
2 dimensional date sort 1
Summing a non continuous range 7
Excel Help with dates 2
Specify a column by the month to calculate it's data 5
Text lookup array and match specific data 3
Cell to the left of an Index function result 2
Lookup Formula 2

Back
Top