SEO SERVICES UK - SEO EXPERT PAUL HODA

Are you ready to get higher rankings in Google search?

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: