I have a cell that has many hyperlinks in it.
Imported via
EDIT─PASTE
CTR─V
EDIT─PASTESPECIAL
All work great to enter all the data into 1 cell.
But
How to import into 1 hyperlink in each cell
or
Split the 1 cell into 1 hyperlink in cells following?
Thank you,
⌡im [THE BookMan]
920.265.5966
Do you want functional links with unchanged anchor strings? Do you want the URL as plain text? What else -except links- can occur in the cells filled with Ctrl+V?
Please attach a small but sufficiently rich .ods file exemplifying what you have and what you want to get.
I’m afraid you will need cuistom code.
Since nobody presented a better idea yet, I attach a demo for what I mean might lead to an actual solution.
Of course, the routine can be enhanced in many ways.
textToHyperlinkColumns.ods (14.6 KB)
Tried several ways, but to no avail.
Problem has got to be in the data.
I guess I’ll just have to copy each individually from the website.
Thank you for your time,
⌡im [THE BookMan]
920.265.5966
As soon as you actually have working hyperlinks in your spreadsheet cells, it’s no longer about any external ‘data’.
Hyperlinks as parts of texts contained inCalc cells are inserted in one specific way.
What I offered as a possible solution should definitely work in the demo if you permitted the execution of document macros when loading it. However, it can’t be used from that location for a different document. To get (try) it working there, you need to copy the code (3 pieces) into a module of your local ‘Standard’ library for Basic scripts.
Note: The solution follows the concept of the tool >Data>Text to Columns..., and requires that right of the column to split there are sufficiently many unused columns to accept the results produced by the split.
Though the solution isn’t “final”, its results should easily be usable.
Without rsorting to custom code there will (imo) not be a solution for your problem.
On the other hand: If the import of the links you want can be done one by one with a reasonable expenditure in time - why not?
For me writing the code was (a bit of) fun and an opportunity to learn something again.
BTW: What you actually wanted precisely is still unclear. Equip your next question with more detailed information, please. And if you are asked to supply an example, please simply do so.
Thanks again,
I have decided to just use toe links on the website.
⌡im
I guess you copied one line of hyperlinks from some internet browser.
Simply copy that line plus any another line. If there are two lines in the clipboard, the text import dialog pops up and you can separate the hyperlinks with Data>Text to columns …
Then delete the other row’s data.