Text not sorting correctly
I have one spreadsheet with 2 columns and 555 rows - I have made sure I have no leading spaces, no hidden rows or columns, no filters -- I've attempted formatting as Text and as General -- but it will sort correctly a portion (to row 314) then a second section correctly sorted. I've tried everything I've seen suggested -- I've even cut the bottom section and inserted into the top section - resorted -- and it still split the data into two separate groups.Solved27KViews0likes29Comments