Sub striptext()
Columns("g").replace "/?", ""
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stan" wrote in message
...
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,