Croping Text to set char eg "/"

[Trances]

Similar to text to coloums but with a formula

I have a coloum of cells ( A )
that has the following
Jim Jackson/DC/London@enter.co.uk
Kim Loydes/HR/London@enter.co.uk
Paul Linter/DC/London@enter.co.uk

in coloum B i want to end up with every thing up till the /

But i dont want to use text to coloums as the data in Coloumn A changes often. I know there is left and right for text but how do you use it to take the chars till it get to set item such as the "/"

 

[Peter_SSs]

Like this? B1 (copied down):
=LEFT(A1,FIND("/",A1)-1)

Mr Excel.xls
	A	B	C	D
1	Jim Jackson/DC/London@enter.co.uk	Jim Jackson
2	Kim Loydes/HR/London@enter.co.uk	Kim Loydes
3	Paul Linter/DC/London@enter.co.uk	Paul Linter
4
Sheet1

 

[Trances]

LOL i just came up the same from the post before
=MID(a1,1,(FIND("/",a1,1)-1))

 

[Richard Schollar]

Here's another approach:

=REPLACE(A1,FIND("/",A1),LEN(A1),"")

 

[Trances]

oh yer that would remove all after and replace with the "" empty space thanks agan