Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

You can use Excel's built-in substitute function to remove or replace a substring of a string of characters in Excel. This can include removing hyphens from Social Security numbers or any other ...