Excel - Convert Hyperlinks Into Html tag

Job ID: 31163489

Budget: $2 – $8 USD

I have a column of hyperlinks in an Excel file and I want to convert them to their respective HTML code:

<a href="http://www.example.com">Link Name</a>

I've searched and searched but no one needed this answer, I guess. Can someone help?
Related categories: Data Processing Data Entry Excel Copy Typing Office 365