I would like an application that takes an Excel document which has text in one cell and a Url in the next that then creates a rich text element that I can copy and paste into a website editor which will remember the Url just like how word does when copying a link from the internet.
Result would be: Tote bags hyperlink I can copy and paste into a rich text editor.
I would need this to be able to have multiple text and links in a row after each other for example:
Cells 1a: Tote bags | Cell 1b : https://www.example.com/cat/bags/womens/tote-bags/. | Cells 1c: Kids' shoes | Cell 1d : https://www.example.com/cat/bags/womens/Kids' shoes/ and so On
Result would be: Tote bags hyperlink I can copy and paste into a rich text editor. Then Tote bags hyperlink I can copy and paste into a rich text editor on the same line.
Another feature needed is defining how many spaces between the results any where 1 space and upwards.
Bonus if the hyperlink can be made relative for example instead of this full Url:
Attached is a screen shot of 4 rows you can use for examples and testing. Just to clarify I want the Rows made into Hyperlinks with readjustable spaces between each hyperlink.
Before starting please clarify if you have any questions and I'll not allow remote access to my computer for the work to be done. Many thanks