Thank you all for your responses! I've had a chance to try the solution provided by sixthsense so far. It worked perfectly - well, almost perfectly. It leaves out the http:// part of the URL. However, with the way browsers work now, that doesn't matter. When the URL is made clickable using =HYPERLINK it works just fine without the http://

FDibbins, thanks for pointing that out. I will gladly include a sample workbook with future questions. I haven't had time to try the other solutions yet but will as soon as I can. In the meantime I will keep using the first one.

Thank you again!