Thread: get rid of slashes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default get rid of slashes
1) =SUBSTITUTE(A1,"/","")

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

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JOSEPH WEBER" wrote in message
...
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