find a character in a string

[kevcar40]

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

 

[Peo Sjoblom]

Ctrl + H, in find what put /, in replace with put a space, then select
replace all

 

[David Biddulph]

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

 

[bj]

select the column
<edit><replace>
enter / in find
and a sapce in replace with

 

[kevcar40]

select the column
<edit><replace>
enter / in find
and a sapce in replace with








- Show quoted text -

thanks all