I have inherited a spreadsheet at work with 5000 data entries. The links behind the data are missing the http:// protocol. Instead of adding http:// to the beginning of every entry, I would like to create a cell with the full hyperlink. I already have 1) a cell with http://servername, 2) a cell with Documents name, 3) a cell with File extensions. I need to know how to create a hyperlink formula to collate the three bits of info