how to replace some values

[jamiguel77]

hi in cell P1 i have this stratic String:

update tleonitodobmwfin set cleonitodobmwaduana='AAA', dleonitodobmwfechapag='BBB', fleonitodobmwtipcamb=CCC, cleonitodobmwcvepedim='DDD', fleonitodobmwvalorcompedim=EEE, fleonitodobmwvaloraduanapedim=FFF, cleonitodobmwfraccpedim='GGG', cleonitodobmwunidad='HHH', fleonitodobmwvalorusdpartida=III, cleonitodobmwfoliovta='JJJ', dleonitodobmwfechafact='KKK' where ileonitodobmwid=LLL

the data strat on row 3 and on column A,B,C,D and so on... in cell P3 i want a formula similar to:
=concat($P$1,) but here is my problem, how to do?

Thanks

 

[t0ny84]

So the value shown for P1 is a combination of the values in Columns A,B,C,etc.?

t0ny84

 

[jamiguel77]

i need replace AAA by cell value of A3 BBB by B3 and so on...

The Value on P1 all is Static.....

i solved the problem:

="update tleonitodobmwfin set cleonitodobmwaduana='" & A3 & "', dleonitodobmwfechapag='" & B3 & "', fleonitodobmwtipcamb=" & C3 & ", cleonitodobmwcvepedim='" & D3 & "', fleonitodobmwvalorcompedim=" & E3 & ", fleonitodobmwvaloraduanapedim=" & F3 & ", cleonitodobmwfraccpedim='" & G3 & "', cleonitodobmwunidad='" & H3 & "', fleonitodobmwvalorusdpartida=" & I3 & ", cleonitodobmwfoliovta='" & J3 & "', dleonitodobmwfechafact='" & K3 & "' where ileonitodobmwid=" & L3

But not use P1

any advice? thanks