Remove slash charaters from a date field

  • Thread starter Thread starter GaryO
  • Start date Start date
G

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.
 
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.
Click to expand...

One way:
=SUBSTITUTE(A1,"/","")
 
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
 
Back
Top