How to extract url from hyperlink column in a Google Doc spreadsheet

Chris Barber-Riley in Google one year ago • 3 min read

=index(SPLIT(SUBSTITUTE(FORMULATEXT(A1),"=HYPERLINK(""",""),""","""),1,1)

Categories: Google

Categories

1

HTAccess

2

SSH Commands

3

vBulletin

4

Expression Engine

5

PHP

6

Git commands

7

Linux

8

SEO

9

Google

10

CSS

11

marketing

12

Javascript

13

MySql

14

help

15

Mongodb

16

Smarty

17

Mac

18

News

19

Server

20

Wordpress

21

Elastic