I'm not sure if this can be done - or if I'm just missing the point. I've tried a few things, but I'm not very good with excel. What I'm looking to do is take a url, a title or description of what site it is and turn both into a hyperlink... like this: | represents new column http://www.glocktalk.com | Glock talk | (a href="http://www.glocktalk.com")Glock talk(/a) ( and ) represents < and > in the example so they're visible on the board. ..and so on with a group of site urls and titles - so essentially I'm looking for excel to generate the 3rd column of code from what I paste into columns A and B. So that column 3 could be cut and pasted into an html document and be good to go. Does this even make sense? I've searched the excel help, google and I can't really find what I'm looking for. Thanks advance for any tips or advice. I appreciate it.