On Thu, 9 Jul 2009 10:41:01 -0700, 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,

If there could be only one "/" in the string, then:

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

If there could be MORE than one "/" in the string, then:

=LEFT(A1,-1+FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

--ron