get rid of slashes

  • Thread starter Thread starter JOSEPH WEBER
  • Start date Start date
J

JOSEPH WEBER

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.
 
Use replace

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

2) Edit | Find & Replace : Find ?; Replace by <nothing>

best wishes
 
Back
Top