Making Two Columns Out of One (Excel 2003)

[chelovek123]

I have a column of data with alternating pieces of information, ABABABABABA, on and on for two hundred entries. Is there an easy way to convert that into two separate columns, one with As and the other with Bs?

Thank you

[davesexcel]

Before anybody looks into this, are you sure about the data?

[chelovek123]

Yes, I'm sure...

[davesexcel]

Try this
Column B
=REPT("A",SUM(LEN(A2)-LEN(SUBSTITUTE(A2,"A",""))))
Column C
=REPT("B",SUM(LEN(A2)-LEN(SUBSTITUTE(A2,"B",""))))
Then drag the formulas down, or double click the fill handle.