Unable to pull alpha contained values to another cloumn

Hi everyone,

Hope u all are doing well, I am stuck with a sheet where I have a few alph numeric and pure numeric digits in a column , I want to get all the alpha numeric values to another column leaving the pure numeric values there.. I tried a lot but ended up in vein. please help it would be appriciable and thanks in advance
uplo.xlsx

I have attached the excel sheet please have a look on to that ..........

Hy thanx for ur reply but my req is not that one I have attached the expected result in the attachemnt please seee and if u can help me it would be grtuplo.xlsm

Thank u so much buddy .. I L U (I llike u) 5 star added!@

hi vpnvipin, no loop, much quicker option

Please Login or Register  to view this content.

watersev u 2 great buddy