Combine =CONCAT and =HYPERLINK?

[szoboken]

I have a list of domains in a column like microsoft.com in cell b2. I insert 2 columns; one have been using =concat to add http://www. to it. then next in another cell using =hyperlink to make it clickable to launch the website from excel.

So can I/what ONE formula can i use if i just have microsoft.com or google.com or ibm.com in cell B2 that COMBINES =concat and =hyperlink so that I can launch the website from excel? THANK YOU!

 

[Jeffrey Mahoney]

=HYPERLINK("http://www."&B2,B2)