Formula for adding (embed) /or (a) tag to a URL

[banghouse]

Need a formula for this scenario:


INPUT:


field 1:

<a href="

field 2: URL

field 3: [code]">

field 4: Link Description (text)

field 5: </a>

OUTPUT:


field 6: <a href="URL">Link Description</a>[/code]


NOTE: I have this setup as field F1=A1&""&B1&""&C1&""&D1&""&E1 but when I try to copy the F column for placing into another sheet that is setup to be used for the actual import into the DB the output is not rendered. The pasted input is a column of =#REF!1&""&#REF!1&""&#REF!1&""&#REF!1&""&#REF!1.


Can't figure out what I'm doing wrong. Please advise. Thanks.

 

[Hui]

Have you tried copying and then Paste Values on the second sheet?

 

[keymaster]

Or pasting them as links.. You may be getting #REF! error because the relative refs become invalid on sheet2.

 

[banghouse]

DOH! paste as link did the trick - how did I not see that? THANK YOU!


Now I'm wondering how can I tell the first sheet to send everything in F1 to A1 in the new sheet?