Hello. In my table I have two columns for coordinates and want to insert them in a third column with a HTML code. How can I do it automatically?
Thanks!
lat lon code
35.076 32.928 <iframe .../35.076/32.928"></iframe>
-1.360 42.592 <iframe .../A2/B2"></iframe>
-5.840 37.338 <iframe .../A3/B3"></iframe>
-4.655 41.932 <iframe .../A4/B4"></iframe>
10.423 51.083 <iframe .../A5/B5"></iframe>Hello,
I’m not sure what you mean, but if you want a formula in calc creating column code, use:
="<iframe .../" & A2 & "/" & B2 & """></iframe>"
="<iframe .../" & A3 & "/" & B3 & """></iframe>"
="<iframe .../" & A4 & "/" & B4 & """></iframe>"
… and so on
alternatively use:
=CONCAT("<iframe .../";A2;"/";B2;CHAR(34);"></iframe>")
=CONCAT("<iframe .../";A3;"/";B3;CHAR(34);"></iframe>")
=CONCAT("<iframe .../";A4;"/";B4;CHAR(34);"></iframe>")
… and so on
thank you so much