Remove slash charaters from a date field

[GaryO]

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.

 

[MyVeryOwnSelf]

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

 

[GaryO]

Thank you very much

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

 

[Jon Peltier]

You could have kept the dates in the cells as dates, and used a custom
number format that omits any punctuation. For example, "yyyymmdd" or
"mmddyy". This would be more useful if you needed the numeric character of
the dates.

- Jon