b6f95285_r_not___videos____Office_Blogs__Question
[Answer] If you just have a few links to create, you can use the Insert Hyperlink command. If you need to deal with a whole bunch of hyperlinks, again, consider the HYPERLINK function. Bonus: Watch Bill take columns that contain bits of a URL and join them into a single URL for use with the HYPERLINK function. [See for yourself] Video: Insert Hyperlink vs. =HYPERLINK [Question] 
When should I use the HYPERLINK function instead of the Insert Hyperlink command? What’s the diff, anyway?
Hyperlinks in Excel: Hot or not? (videos) - Office Blogs
Question