This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have an Excel sheet with 30 columns and over 8,000 rows. I have to sort business customers from personal customers. The easiest way to do this would be by using the column containing the ssn/tin #. Personal ssn #'s are formatted xxx-xx-xxxx and business tin #s are xx-xxxxxxx. So i have to figure out a way to sort all rows according to cells in one column that contain two digits followed by a dash from cells that contain three digits followed by a dash.
Any suggestions?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
If the personal/buis SSN's are in the same column simply select that column, click Sort>Expand selection