Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replacing text within a formula
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replacing text within a formula
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replacing text within a formula
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. "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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replacing text within a formula
You are very welcome.
-- Gary's Student gsnu200702 "jimswinder" wrote: 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. "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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replacing text within a formula
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. -- Regards Roger Govier "jimswinder" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting text string back into a formula | Excel Discussion (Misc queries) | |||
Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Invisable text in formula bar | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions |