delete all after site url in excel

[kisanvikas2015]

Hi all,

I wanna delete all the text after website url.

File is attached.

Regards,
Vikas

[NeedForExcel]

Will the URL always have ".com" at the end?

[ashishmehra2010]

Hi Vikas,

In cell B2 copy & paste the formula

Please Login or Register  to view this content.

& then drag down.

Regards,
AM

[kisanvikas2015]

Will the URL always have ".com" at the end?

Yes ".come" will be at the end

"http://www." from starting

sorry for confusion

Regards,
Vikas

[NeedForExcel]

Try ashishmehra2010's solution..

It will work perfectly for you..

[ashishmehra2010]

@NeedForExcel: Thanks for your kind words.

@Vikas: Please mark the thread as SOLVED.

Regards,
AM

[kisanvikas2015]

Thread is SOLVED