Seperate text and numbers into 2 columns

[Big Swey]

I need the text and the numbers in two separate columns and still maintain row "identity"

ADR
112
90
49
41
45.56%

Any Help greatly appreciated. Probably easy but I'm STUCK
thanks Big Swey

[hemesh]

Hello Big Swey you can use formula in B1 as IF(ISTEXT(A1),A1,"") and in C1 as =IF(ISNUMBER(A1),A1,"")
Hope this will help if not then you can upload a sample file with how you want your data to look like

if helped please add a *

[Big Swey]

Perfect this worked great.. thanks much Hemesh