Weird Sort Results

This weird behavior occurs in VBA, or by sorting manually and is repeatable:

Enter a value in cell A1 and A2
Select Column A
Sort Column A (Data/Sort)

Now clear or enter space in cell A2 so only cell A1 is filled in
Select Column A
Sort Column A

The value in cell A1 is moved to cell A2

This only happens if cells A1 and A2 have values and are sorted first. If only A1 is filled in and sorted first, the move does not happen

If you are wondering why I'd want to do a sort when only one cell is filled, I came upon this using VBA where a column may have one or more cells filled in. My workaround was to check to see if there was more then one cell filled before doing the sort. But why is this happening and is there a real fix?

Thanks ProtonLeah! You nailed it! My instructions were wrong. Typing spaces in the cell causes the shift. Clearing the cell makes it work as expected.

I had thought the sort selected cells until it hit a blank cell. I guess it does, but spaces are not "blank"
Not realizing that had caused several mysterious issues with a project I was working on... That, and UNICODE collating sequence being the opposite of the EPCDIC collating sequence I was accustom to as a life long IBM mainframe programmer.