Replace text in middle of string and apply for multiple entries

[boldee]

Hello Excel Guru's,

Here is my situation, I wouldn't say it is very complex situation, but I am new to excel functions and formulas.
I would like to replace right column entry to in between left column entry, For example: One right column first entry is " DE2K903204" should be replace in left column entry tp ADDTOBUFFER DE2K903204 SE1, similarly second entry in column B should be replaced inside column A entry.

tp ADDTOBUFFER DE2K902981 SE1	DE2K903204
tp ADDTOBUFFER DE2K902981 SE1	DE2K903031
tp ADDTOBUFFER DE2K902981 SE1	DE2K903033
tp ADDTOBUFFER DE2K902981 SE1	DE2K903098
tp ADDTOBUFFER DE2K902981 SE1	DE2K903198
tp ADDTOBUFFER DE2K902981 SE1	DE2K903200

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[Michael M]

I'm guessing it's way more complicated than this, but....
in cell C1

="tp ADDTOBUFFER " & B1 & " SE1"

drag down as required

 

[boldee]

I'm guessing it's way more complicated than this, but....
in cell C1

="tp ADDTOBUFFER " & B1 & " SE1"

drag down as required

Hello Michael,

Thanks for your prompt and correct response as I was expecting and the formula works, but I would like to make some more changes.
What if I want to add some code beyond replacing with right column to left column. If I add some text after after replace formula provided does not work.

tp ADDTOBUFFER DE2K902981 SE1 pf=\\EAYSSAP300\sapmnt\trans\bin\TP_DOMAIN_SE1.PFL

DE2K903031

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[boldee]

Hello Michael,

Thanks for your prompt and correct response as I was expecting and the formula works, but I would like to make some more changes.
What if I want to add some code beyond replacing with right column to left column. If I add some text after after replace formula provided does not work.

tp ADDTOBUFFER DE2K902981 SE1 pf=\\EAYSSAP300\sapmnt\trans\bin\TP_DOMAIN_SE1.PFL

DE2K903031

<tbody>
</tbody>

I was able to figure out answer for my second question, all I have to do is include the additional text right before the second parenthesis so it appears along with replacement.

Thanks for your input here and helping me figure with my requirement.

Regards
Sandeep A