You can use the HYPERLINK formula :
Either in another column:
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).
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,