Separating text in one Column into two Columns

[shield5]

Hi



Attached an Excel sheet that contains text in Column A, What I would like to do is separate the text in the table of contents, under the Description heading text goes in column B, While the text under Values heading to goes in Column C.

Thanks

[xor]

Should A3 and A4 (and similarly A5 and A6) be regarded as one description?
If yes then I have no ideas.

[shield5]

Originally Posted by xor

Should A3 and A4 (and similarly A5 and A6) be regarded as one description?
If yes then I have no ideas.

Yes it is one description.