Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering dates without having to use slashes? | Excel Discussion (Misc queries) | |||
Excel Dates w/ No Slashes | Excel Worksheet Functions | |||
hyphen to forward slashes? | Excel Discussion (Misc queries) | |||
How do I use hyphens instead of slashes when representing dates? | Excel Discussion (Misc queries) | |||
how to put date slashes in to a column of number | Excel Discussion (Misc queries) |