URL extraction from text.

[stefanoste78]

Good afternoon.

I have an excel file where in column a there are urls or urls with separate text or linked to the url.

I would need a formula or macro that analyzing column a returns in column b the url of the first libellus without text that precedes or follows the url.

To this end, I attached an example excel file where I tried to insert more formulas. Obviously I am interested in one that gives the same final result as that of column d

The URL may end with .com or other URLs

Thanks

 

[Peter Bartholomew]

I think this is still only available on the insider beta channel.

= REGEXEXTRACT(URL, "(https://)?(\w|\.)*/?")

Notes
(https://)?  Exact characters 0 or 1 times
(\w|\.)*     Combination of word characters and backslash \, any number of times
/?           An optional final forward slash /.

 

[stefanoste78]

I think this is still only available on the insider beta channel.

= REGEXEXTRACT(URL, "(https://)?(\w|\.)*/?")

Notes
(https://)?  Exact characters 0 or 1 times
(\w|\.)*     Combination of word characters and backslash \, any number of times
/?           An optional final forward slash /.

It doesn't work. Maybe this depends on the non-English language or the excel version?

 

[Peter Bartholomew]

It certainly requires Excel 365 (as does every other formula I write) but I would need a translation add-in to know whether the function name varies according to locale.