I got huge reports with the SSNs containing dashes. How do I remove them without having to go through each one of them manually? I know it requires a function and formatting the entire column.
I've tried setting the column to Custom (SSN), but it's not doing anything. What's the actual function to remove the dashes?
Last, how do I add an additional digit to that formula so that all SSNs are 10-digit starting with a zero?
Any help with this is greatly appreciated! :bald:
I've tried setting the column to Custom (SSN), but it's not doing anything. What's the actual function to remove the dashes?
Last, how do I add an additional digit to that formula so that all SSNs are 10-digit starting with a zero?
Any help with this is greatly appreciated! :bald: