get rid of slashes
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. |
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. |
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. |
All times are GMT +1. The time now is 01:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com