davecurrierseo

# step 1 - make sure the rich text links are in column (a)
# step 2 - export sheet as a webpage (.html)
# step 3 - open sheet in chrome, open dev tools and paste this in the console:

let cells = document.getElementsByTagName('td');

for (let i = 0; i < cells.length; i++) {
    let links = cells[i].getElementsByTagName('a');
    for (let k = 0; k < links.length; k++) {
        if (typeof links[k] !== 'undefined') {