office@paulhoda.co.uk   |  WhatsApp: +44 7861505921   |           Welcome to the website of Paul Hoda, an SEO Expert, Specialist & Consultant, CSS Developer and Link-Building Specialist, offering local SEO services in the UK.

How to convert a column of text URLs into ahref hyperlinks in Excel?

Nov 22nd, 2019Comments Off on How to convert a column of text URLs into ahref hyperlinks in Excel?

This is for everybody who is playing a lot with Excel and has many links that are not clickable.

1. In the B column type in the formula =HYPERLINK(A1,A1) for the first item that is in A1.

2. Then copy the formula down the rest of the entries.

Autor: