I need to copy a column that has linked text and paste a column that shows all the URL’s for the linked text
This post discusses extracting the URL from a cell with a link in it using a custom formula.