Search and replace string in formula with string from cell

[Ingar]

Hi!
Say I have a formaula in a cell like this:


="This year is"&" "&Year(2003)

I would than like to put in a cell, like A2, a number like
2004

Is it then possible by search and replace to have (2003)
replaced by the value in A2?

The formula is just a example in this case not an actual
formula.

I hope someone can give me a tip on this

Thanks
Ingar

 

[Tom Ogilvy]

Yes

Replace what 2003
Replace with A2

Only select a range that contains cells that you want changed (if there is a
chance of 2003 appearing where you don't want it changed).

 

[Tom Ogilvy]

Sorry - misunderstood what you wanted. I thought you wanted the formula
being changed to refer to cell A2 rather then have a hard coded value.

No, you have to put the string literal in the Replace with textbox in the
Replace dialog.