Either select your column and:
Edit
Replace
Find what: /
Replace with: {type in a space}
or use the formula
=SUBSTITUTE(A1,"/"," ")
--
David Biddulph

"kevcar40" wrote in message
ups.com...
hi
i have a column of text data

i would like to search over the column and search each string for the
char "/"

if it exists in the string i would like to delete it and leave space
in its place

thanks kevin