I used a macro to separate two columns, column A & B. The first "A" that was
supposed to end up in column "B" did not. It ended up in column A at the end
of the text string, but only in the cells that start with "A". What's the
best way to fix this?