Thread: get rid of slashes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default get rid of slashes
Use replace

MyString = "AARON ED-25Z NEW NATL 1/18/08"
MyString = Replace(MyString,"/","_")

"JOSEPH WEBER" wrote:

AARON ED-25Z NEW NATL 1/18/08

How can i get rid of the slashes in this? Is there a formula i can use? I
have a macro that automatically names files and the slashes can't be in the
name.
Reply With QuoteReply With Quote