This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've discovered something I feel could be a drastic improvement in time with the Text To Columns tool. Frequently we have to split out data such as SSNs and ZIP Codes. From 9 digits to say XXX XX XXXX for SSN in order to mask data or from 9 digits to XXXXX-XXXX for ZIP Code or split it into into two separate cells. If the data is received with no delimiter, there is no way in text to columns to easily separate it without complex code. I asked for a way to do this and didn't get a clear response from firstname.lastname@example.org for about a week after being unsatisfied with the basic and incomplete explanations I was receiving. Finally a Sr Customer Support Engineer gave me this complete answer using string function formulas: