Hi Guys,
I have a list of websites some full and some are missing the beginning eg. "/Interview.html." instead of "http://www.cnn.com/interviews.html" .
I want to write an if/then statement that says "if cell A1 doesn't start with 'http' Then add 'http://cnn.com' to url and add to current cell, otherwise, copy to current cell"
Any help is greatly appreciated
Thank you
Bookmarks