how to paste link target to the new column in excel

Below screen shot may help you…. Please let me know if you have any questions..

Suggestions are always welcome..!  Without signing also you can send your comments.