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

Thank you very much

"MyVeryOwnSelf" wrote:

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,"/","")