Regex - Link formatting

Question

I have the following link in excel:

http://en.wikipedia.org/wiki/Melon_Bicycles

I would like to retrieve the link as: http://en.wikipedia.org

In google doc I used: =REGEXEXTRACT(A1; "https?:\/\/(.[^\/]+)"), whereas A1 is the cell with the unformated link.

Any recommendation how to implement that in excel 2010?

See answer from http://stackoverflow.com/questions/22542834/how-to-use-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops — Andrey Ganin, Mar 03 '15 at 14:13

score 1 · Accepted Answer · answered Mar 03 '15 at 13:42

1

A simple approach would be to use LEFT with FIND. Something like this

=LEFT(A1,FIND("/",A1,9))

enter image description here

answered Mar 03 '15 at 13:42

Pankaj Jaju

1 Answers1