how to replace part of r1c1 formula with cell value?

[felpslima]

Hello!

I'm having a lot of trouble when trying to find and replace a certain part of a formula written in column B with the cell values in column A.

In column B I have written the following code "=TWSVR|CMA!'0012XXXX;1'"
In column A, I have several names.

What I need to do is to is to find a way to put every A value into its B equivalent row within this formula.

Can anymone help me?

Thanks!

[Bob Phillips]

Try

=INDIRECT("TWSVR|CMA!'" & TEXT(A1,"0000") & "XXXX;1")

[felpslima]

Thanks for your reply, but it didn't work...

[Bob Phillips]

Then we need clearer details on what you want, I just took a punt.

[felpslima]

Can I upload a sample sheet then?

Then we need clearer details on what you want, I just took a punt.

[Bob Phillips]

Yes you can, select the 'Go Advanced' button below the message box, and then there is a 'Manage Attachments' button to do this.