Search and Left Function

Hello,

On row A, I have data such as http://www.dafsdfasfd.com/dfsfdds.php?=dsfsd

etc.

What I want to do is have excel display only result up to and including first "/", so desired result would be, http://www.dafsdfasfd.com/

the formula I tried, without success was , =AND(SEARCH("/",A5),LEFT(A5,"/"))


any idea how to fix, thanks in advance. i've attached a sample file for reference

thanks bud worked perfectly few questions, one why did you use 8? for MID(A2,8,LEN(A2)))+6)

also could you perhaps translate in plain english, as far as I understand it,

i.e. search for "/", starting in cell a2 (MID),starting at position 8, by +6 characters (hence, LEN(A2)))+6), all to the left of original search "/"


i know I botched that up

thanks bud/mudraker...2nd formula makes sense to my newbie excel head. I really appreciate you taking the time to help me.