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!
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!