Is this is possiable

[nianchi111]

Hi,

I have an excel, in which there are so cells has an Hyperlink to it.

A1 = Visit my website this is the website which is inside this."http://financialservicesinc.ubs.com/fa/glenrauch/"

Is there a way to extract the website to B1.

Thanks,
Nianchi111

 

[Haseeb Avarakkan]

Hello, Try

=SUBSTITUTE(REPLACE(A1,1,SEARCH("http",A1)-1,""),CHAR(34),"")