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?

Start by posting your macro code here and maybe we can figure it out. It
also helps if you'll post some "before" and "after" example data to go along
with it.

"LeisaA" wrote:

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?