View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KS[_2_] KS[_2_] is offline
external usenet poster
 
Posts: 5
Default Replace character in string, not document

Hello all.

I have a macro in which I save the document creating the filename based
on selected text in the document. However in some cases, the selected
text looks like "995451/U." Obviously I cannot save using this name. I
would like to convert this to "995451-U" for saving purposes only but
NOT in the document. How can I do this?

Thanks,

KS