How to replicate an anchor tag in Excel

0

I have an Excel (csv) like this:

column1  link
yahoo    <a href="www.yahoo.com">Yahoo</a> 
google   <a href="www.google.com">Google</a>

Is there any way to make link column behave like a normal anchor tag, such that it shows like: 

column1  link
yahoo    Yahoo (clicking it should redirect) 
google   Google

I can use macros or any tips while exporting this in csv.

coolguy

Posted 2014-10-09T10:00:05.420

Reputation: 143

What have you tried already? You could record a macro creating a link and use that code to format your data.. – Raystafarian – 2014-10-09T10:03:11.900

Answers

1

This is not possible as a csv file. You would have to convert it to a proper Excel file - a .xls or .xlsx file to display hyperlinks as text.

user

Posted 2014-10-09T10:00:05.420

Reputation: 42

Asked: 2014-10-09T10:00:05.420

Viewed: 408 times

Active: 2014-10-10T16:46:53.960