The data in my column A looks like this, and column B is just short text:

111ABC-1
111ABC-2
112DEF-1
112DEF-2

I even posted the relevant data to a new sheet so that all I had were
columns A and B, but I got the same results.
Maybe it's something in my settings.