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?
Need a formula for this scenario:
INPUT:
field 1: <a href="
field 2: URL
field 3: ">
field 4: Link Description (text)
field 5: </a>
OUTPUT:
field 6: <a href="URL">Link Description</a>
NOTE: I have this setup as field...
Hi I'm Joel from NYC.
I'm a Drupal web guy. I'm currently working on a project that requires importing very large CSV files into MYSQL through Drupal as individual nodes with multiple fields. Some of that data needs to be processed in Excel before it gets imported. Sounds like a lotta fun...