I have a SharePoint library where I upload documents and another list where I would like to link those documents to rows. Here are the steps I am taking:
I upload a document into the library and it gives me a simple link "doc1.pdf" in the column. The URL, when you hover over the link, points to the actual document but the link itself in the library column is short and simple and does not have the entire http://www.blahblah.com/doc1.pdf
I export this library to Excel
The link in the column shows "doc1.pdf" but, when you hover over it, shows that it points to the correct location. If I were to Edit Hyperlink in Excel, it shows the whole URL in the 'Address' and doc1.pdf in the 'Text to Display'.
I then open the list in Quick Edit and attempt to do a simple copy/paste of the URL "doc1.pdf" from the exported library in Excel into the list in SharePoint.
All that copies over is text "doc1.pdf" and no link. The column is Enhanced Rich text. If I create a hyperlink column, then the link simply shows an error because "doc1.pdf" is not a link.
How do I quickly and easily copy the actual LINK for "doc1.pdf" from the library into the list without have to edit each and every link in Excel? I have over 1,000 of these links to copy over.
3rd party or external software is not an option, unfortunately,

