URL links in table not showing address

I want to have links in my spreadsheet, but without showing the address, I assumed using < href=”…”>link

example
the file is here: https://www.oceansideartwalk.org/wp-content/uploads/2014/07/2014-08-01-ArtistVenueForWebsite8.csv

I want to link to the page https://www.oceansideartwalk.org/trevor-coopersmith/ so I did this:
<a href=“../../../../trevor-coopersmith/“> Trevor Coopersmith</a>

and it sends me here:
https://www.oceansideartwalk.org/trevor-coopersmith/%E2%80%9C
which spits out a ‘page not found’ error

What can I do?

https://www.ads-software.com/plugins/csv-to-sorttable/