Hi Macropod,

That doesn't sound like the solution I need because we are talking about three to four columns/articles per day and upwards of 10 to 50 different player names in each article (and each player's full name is only mentioned once per article - so a find/replace is unnecessary). By the time I'm done looking up each player on the spreadsheet (say 1000 names/links), copying the hyperlink, and adding them one by one...would take a long time.

I'd like a macro that would scan the article, pick out the player names that match what is on the Excel list, and insert the hyperlink. All players mentioned get linked with one click.