View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default find a character in a string

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


--
Regards,

Peo Sjoblom


"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