Extract text before first forward slash

[isadoko]

XP
Excel 2003

I have cells showing text data like this:
BD/JOHNSON&COELHA/CF#WQ8J5D
CXLD/DUTHCER/523342

I want to extract the varying length characters strings from left to right before the first forward slash only.

Thanks for the help

 

[AdamL]

XP
Excel 2003

I have cells showing text data like this:
BD/JOHNSON&COELHA/CF#WQ8J5D
CXLD/DUTHCER/523342

I want to extract the varying length characters strings from left to right before the first forward slash only.

Thanks for the help

=LEFT(textstring,FIND("/",textstring,1)-1)

should return everything to the left of the first "/".

 

[PaddyD]

=left(a1,find("/",a1)-1)

 

[isadoko]

Great! Forgot one other piece I must combine with vlookup:

=VLOOKUP(J2,AGTNAME!$A$1:$E$3086,5,0)),"",VLOOKUP(J2,AGTNAME!$A$1:$E$3086,5,0))

Again thank you