jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 387
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
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
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