December 21, 2019
I would like to sort my data by the HATS number (located in column A) but when instead I am being returned two sets of results. cells 1 through 5499 get sorted(from lowest to higher) then cells 5501 through 6152 get sorted the same way.
How can I have all the data sorted together
December 20, 2019
Looks like the data has been input in 2 different formats - rows 2 to 5498 show (for example) 999-04-0558 but the number is really 999040558. The second column below is with no formatting.
But 5499 onwards it is input with the dashes
You could add a formula to make the numbers into the dash format - the below seems to work (added in column C).
I then copied column C, pastespecial> values and sorted (yellow rows are the 5499 onwards rows), seems to work
fyi - I have saved the file as xlsb to get around the 1meg file upload limit - there is no vba in it