Hi, I've inherited an inventory list that has a field (column) with a hyperlink to the online item. The Text to Display section is standard for all items "View Vehicle" with a unique Address URL for each item. I would like to have the actual URL address show vs "View Vehicle"



Without going item by item for hundreds of lines, is there a way to mass update?

Reason I need to show the URL address is I need to update components of the address - basically a find and replace action.

Using Excel 2013

Thank you for your help.
Chris