Hi,
thanks for your question, and sorry for the trouble.
Importing links from Excel is not possible, I’m afraid, as they use different technical mechanisms.
When re-creating them with the “Insert Link” button, it is important that the link text appears between the HTML tags, like
<a href="...">Link Text</a>
Is that the case in your table?
Regards,
Tobias
Thread Starter
mdelfs
(@mdelfs)
Hi Tobias,
Thanks for the quick reply!
When using the link button, below is added to the cell text:
There is not space the last character in my cell and the string above.
Best regards,
Mdelfs
Thread Starter
mdelfs
(@mdelfs)
Last line should have read:
There is no space between the last character in my cell and the string..
Hi,
I’m not really sure what you mean here. Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!
Regards,
Tobias
Thread Starter
mdelfs
(@mdelfs)
Sure..
http://u16kew1.nixweb10.dandomain.dk/?page_id=2
So now, the full cell value is:
Lenotti, Le Olle Bardolino Classico
My cell value is: Lenotti, Le Olle Bardolino Classico
The rest has been added by the insert link function. When I preview the table, of course only my cell value is present, but there is just no link.
Again, thanks for helping out 🙂
Thread Starter
mdelfs
(@mdelfs)
Okay, now I understand why you don’t understand..
When I write html in the post, it is just deleted.. Hmm..
Can I upload a picture here or write you directly somewhere?
Hi,
thanks for the link! Just as I had thought, you will simply have to move the desired link text into the HTML code, as in the example above.
For example, change
Lenotti, Le Olle Bardolino Classico<a href="http://u16kew1.nixweb10.dandomain.dk/?p=1" target="_blank"></a>
to
<a href="http://u16kew1.nixweb10.dandomain.dk/?p=1" target="_blank">Lenotti, Le Olle Bardolino Classico</a>
Regards,
Tobias
Can I upload a picture here
Unfortunately, we do not have the ability to upload images here. But you could use http://snag.gy/ and post a url for the image here.
Thread Starter
mdelfs
(@mdelfs)
Ok, thanks for this!
Is there a reason it doesn’t not do that automatically when I use the link function. It knows the cell value and I provide the URL, so should it not be possible to join this in a way so it does this by itself..?
As you see, I have quite a lot of links to update, and more will come. Do you know an easy way of doing this or is it just hard work all the way through? 🙂
BR, Mdelfs
Hi,
you can use the “Insert Link” feature, you will simply have to cut and paste the existing cell content into the “Link text” field (via Ctrl-A, Ctrl-X, and Ctrl-V on the keyboard).
With that, the “Insert Link” button will create the correct HTML code.
Regards,
Tobias
Thread Starter
mdelfs
(@mdelfs)
Hi Tobias,
Thanks for the help. I got it to work.
This is much appreciated!
BR, Mdelfs
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes,
Tobias
