How to get rid of Slash character from Date in Excel

[HangDown]

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.

[Hollyn]

There is a simply way to do the same. You can do that by using a formula =SUBSTITUTE(A1,"/",""). Insert this in the next cell and then drag it below. It will let you to get the dates without slash.

[QUENBY]

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.