Replace Part of formula with values from another cell

[murexcel]

Hi,

I'm trying to replace ABCDEFGHIJ with value in another cell.

Eg the below data is in A2, so I want to replace ACBDEFGHIJ with value in B2.

("1guQU2iTix2Ond4cU7akcXm5_vc9HvxbDPZxUQZ7PPQg","ABCDEFGHIJ!I2")

Thank you.

 

[Joe4]

Take a look at the SUBSTITUTE function.
See here for details and examples: SUBSTITUTE Function

 

[murexcel]

I tried, but the formula does not allow to pickup cell value. I have to enter the text in the formula. So I cannot reference another cell.

 

[davesexcel]

This looks like a partial formula. and it looks like you want to replace the sheet name in the formula with a sheet name in B2.

Indirect would be required but you need to supply the entire column

 

[murexcel]

Left has the formula, right has the sheet name to be replaced.

IMPORTRANGE("1guQU2iTix2Ond4cU7akcXm5_vc9HvxbDPZxUQZ7PPQg","ABCD123456!I2")

ABCD78910

The number of characters will keep on changing to formula based on characters would not work.

 

[Joe4]

I think your formula should look something like this:

=SUBSTITUTE(A2,"ABCDEFGHIJ",B2)

 

[Fluff]

@murexcel is this for Excel or some other software?

 

[murexcel]

Thank you, that works.

 

[Joe4]

You are welcome.
Glad we were able to help!

The key to remember with all Excel formulas is that you can put cell references wherever it is expecting a value (you don't need to hard-code the values in to formulas).