Match data one column to another column

[Rahul Mishra]

Sir ,
How can i match alfha numeric data from only alfa data ?

 

[Somendra Misra]

Hi Rahul,

can you also mention the result in your file.

Regards,

 

[Rahul Mishra]

same of match column sir

 

[Khalid NGO]

Hi Rahul,

Have a look at this link:
http://www.mrexcel.com/forum/excel-questions/443983-extract-only-numbers-text-string.html

You have to change your file in xlsx format, then try below formula:

=SUMPRODUCT(MID(0&A2,LARGE(INDEX(ISNUMBER(--MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))*
ROW(INDIRECT("1:"&LEN(A2))),0),ROW(INDIRECT("1:"&LEN(A2))))+1,1)*10^ROW(INDIRECT("1:"&LEN(A2)))/10)