Im looking for a formula =SUBSTITUTE(I2, "{keyword}", "test") but in place of the word test i want to use a cell reference like C2. Can you use substitute in this way?
Im looking for a formula =SUBSTITUTE(I2, "{keyword}", "test") but in place of the word test i want to use a cell reference like C2. Can you use substitute in this way?
Definately.
=SUBSTITUTE(I2, "{keyword}", C2)
do you not think it might have been quicker to try it? than post on a forum and wait for a reply?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Have you tried it?
Yes, you can do that.
I2 = I love this junk
C2 = stuff
=SUBSTITUTE(I2,"junk",C2)
Note that SUBSTITUTE is case sensitive. "junk" must be an exact match of junk in the source string.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks