If you have the data in colA

In CellB1
=LEFT(A1,FIND("/",A1)-1)

and copy down as required..

If this post helps click Yes
---------------
Jacob Skaria


"Stan" wrote:

I have about 500 cells that end with /2, /3, /4, etc.
is there a way to get rid of any character that follows "/", including "/"?

thanks,