Solved: Auto-populate column with hyperlink code

[Saabeirik]

Hi!

I've made a large Excel-sheet with information. I'm going to convert it to CSV, and import it to a MySQL-database for display in my Joomla-site.


I want to make a new column with "hyperlink code". I'm not sure how the code should look like, so that it will be interpreted as a hyperlink. It will probably be some sort of PHP-code.


To the point!
I want to populate each row with a PHP-code, related to another column in the same row:

Example:

Fruit__________Price___________________________Link
Bananas_________$3___________________________ www,fruiters,com/samples/bananas.jpg
Oranges_________$7___________________________ www,fruiters,com/samples/Oranges.jpg


Is there an easy way to populate the LINK column with URLs related to the Fruit column? I'm hoping you understand what I mean, and I can probably apply the principle to my needs if given some help :) If there's an easier way without VBA I'm of course interested in that too.

Thanks in advance for your time!

[Ringhal]

I used the concatenate function to make this hyperlink.
Attached is the file with the function

[Saabeirik]

Thank you Ringhal!

This worked perfectly ;) I used the concatenate function to generate HTML-code for 500 hyperlinks. Saves me a lot of time!