erichepperle wrote:I tried your suggestion:
* Select the column with the web addresses then: Format → Cells → Numbers → Format Code → =HYPERLINK("\"@\"")
…
But, it didn't work. Or possibly I'm misunderstanding the instructions.
Thank you for the detailed problem documentation. You have misunderstood the instructions. First, the dialog below which showed you a single row in the Text to Columns dialog means that you failed to follow this admonition:
→ → → Be sure to select the column, for example click the A above cell A1, in
each of the four steps.

- This dialog, which shows a single row, should show all the rows.
- Screen Shot 2019-02-18 at 10.58.52 .png (8.6 KiB) Viewed 386 times
Next, the format code is incorrect. Here is what is in the tutorial:
→ → → If you do have the http:// prefix in the cell, use format code
"=HYPERLINK("\"@\"")" instead.
The format code is pink. Note that the outside quotes are pink. The color is to show that they are part of the format code. I am confident the instructions will make this conversion for you. I tested them when I created the tutorial and tested them again today. This is what you want.

- The correct Format Code
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6. The locale for any menus or Calc formulas in my posts is English (USA).