I have the formula's for SSN validation and formatting but my users want to use TIN numbers.
This is what I have for SSN (xx-xxx-xxxx)
concat(substring(translate(., "- ", ""), 1, 3), "-", substring(translate(., "- ", ""), 4, 2), "-", ...