Excel 2007 : Separate Column with Text and Numbers into Two Columns

I am copying and pasting a list of text values and numbers. The text values are on top, and their corresponding numeric values are on bottom:

Three
Two
One
3
2
1


While leaving the original column of data as is, I need to create range that references the original but separates the text and numeric values into two different columns. The final product should look something like:

Three
Two
One
3
2
1


Three 3
Two 2
One 1

Hi,

One way, in B1 and copied down

Please Login or Register  to view this content.

adjust the A1:A6 as necessary

HTH