View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default replacing spaces?

hi

I have cells whose values are like:
K-TGF
PCR 90 Q
TGF 800 T

i want to check that if anywhere spaces " " or slashes "/"
or "-" comes i want to remove it so that fianlly my result
is:
KTGF
PCR90Q
TGF800T

what is the easist method?

thanks in advance