Sorting cell row alphabetically

Good morning all,

I'm trying to sort through product numbers (alphanumeric) to update price changes from the tariff. I have 6 columns that are filtered. From left to right, SKU (our in-house product number), Product Description, Brand, Product Number (Brand's product number), List Cost, and Price (our list cost). All the cells in the product number column are formatted to be text and when I try to sort them from A to Z it doesn't sort properly. I do have a lot of cells I'm working with in 2 of the columns (List Cost and Product Number). About 10k+ in both those columns. Example of improper sorting shown in attached Excel file. To see everything you are working with, hold ctrl and press down on the dpad to see the extra data in the product number and list cost columns. Every product number has a duplicate pair with an updated price to the right in the same row under the column list cost. Improper Sorting.xlsx

Any idea how to fix this sorting issue?

Thanks for the help!