View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default find a character in a string

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

"kevcar40" wrote:

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