You can use the HYPERLINK formula :
Either in another column:
=HYPERLINK(F4,C4)
Either if your URL are all the same, you can use Left, Right and Mid functions.
Tell us if you need an example.
[EDIT : an example !]
Let's assume your URL begins with "www." and ends with a dot "." and several characters (assuming we don't know how many).
=HYPERLINK(F4,PROPER(MID(F4;5;LEN(F4)-SEARCH(".";F4;LEN(F4)-5)-1)))
My excel version is not in english so tell me if it does not work. At least, i hope it will give you some clues on how to manage it.
Btw, some caveats :
- domain names cannot be longer than 4
char (cf. LEN(B1) - 5 part of the formula)
- if there are some dots inside the name, they will remain and the PROPER formula will upper the case --> this can be treated by a REPLACE formula
Hope that will help,
Regards,
Max
Wow, thanks for the answer! Can you give me an example? – Blim – 2011-06-22T14:30:33.983
Also, for row C with the Data, how can I add the =Hyperlink formula without replacing the actual text? – Blim – 2011-06-22T14:37:38.957
You'd better use another column with the formula. You can even hide the column C afterwards – JMax – 2011-06-22T15:05:40.877
Thank you. When I create the new column, how can I have the formula generate the inputs automatically? So, =Hyperlink (F4,E4) (F5,E5) etc. – Blim – 2011-06-22T16:51:44.507
not sure i understood your question but i'll give it a try : you can enter the formula in a new cell (let's say on G4) : =HYPERLINK(F4,C4) and then, you only have to drag it down (http://www.handyexceltips.com/2008/01/16/dragging-a-formula-down/) to the end of you data. If it does not answer your question, feel free to let me know
– JMax – 2011-06-23T05:37:46.607