View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default Remove slash charaters from a date field

How do I remove the slash characters from a date field. I have
converted all the date formats to text and need a way to remove the
slashes.


One way:
=SUBSTITUTE(A1,"/","")