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 a combination of inventory part numbers that are either 6 digit or 6 digit with - and two more digits. Example:
131357 and 131357-01. How can I sort this list as a whole to integrate the -XX numbers with the 6 digit numbers? I want to get this result:
| 291678-03 |
|---|
| 291678-04 |
| 291734 |
| 291747 |
| 291753 |
| 291756-01 |
| 291764 |
| 291810 |
Thank you!
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.
Answer accepted by question author
I used two helper columns.
I sort by fields Left and Right
The inset shows the starting data
best wishes
Great! Thank you so much for your time!