Google Sheets SEO Users - I have found a neat way of turning URLS into backlinks without a formula.

This is one thing with Excel & Google Sheets that drives me absolutely nuts.

There is no easy way to turn a list of URLs into hyperlinks whilst keeping the same value and not needing to use a code or a helper column. Thought I would share in case anyone else has this issue:

Creating hyperlinks to a huge amount of URLs in Google Sheets without the use of a formula, or copying and pasting from word.
1. CTRL F: Find & Replace
2. Find: http
Replace: seo4lyf
3. Find: seo4lyf
Replace: http

Automatically turns URLs into links.

submitted by /u/seo4lyf
[link] [comments]

from Search Engine Optimization: The Latest SEO News https://www.reddit.com/r/SEO/comments/d809ts/google_sheets_seo_users_i_have_found_a_neat_way/>