- Joined
- Jul 4, 2008
- Messages
- 5
- Reaction score
- 0
[font="]Dear sir[/font]
[font="]I have list of 15000 of Alphanumeric data for ex. ADEDO125ADSD589ADF121,UIEIROIWS12556ERE545,ADAS15455212AD4564AD2[/font]
[font="]And so on. Now I want to extract number from this alphanumeric. Once I have seen a formula of (SUBSITUTE) a Month Before in a excel related site. It was so simple that any body can use that formula. Its very short formula. For Ex. A1:A1500 has alphanumeric data put the formula in B1 and drag this formula to B7. In B7 You will find the only number. I will make lots of search but couldn’t find the answer[/font]
[font="]If you can help me in this matter[/font]
[font="]It Will Be most of the most Appriciate[/font]
[font="] [/font]
[font="]Regards [/font]
Hardeep
[font="]I have list of 15000 of Alphanumeric data for ex. ADEDO125ADSD589ADF121,UIEIROIWS12556ERE545,ADAS15455212AD4564AD2[/font]
[font="]And so on. Now I want to extract number from this alphanumeric. Once I have seen a formula of (SUBSITUTE) a Month Before in a excel related site. It was so simple that any body can use that formula. Its very short formula. For Ex. A1:A1500 has alphanumeric data put the formula in B1 and drag this formula to B7. In B7 You will find the only number. I will make lots of search but couldn’t find the answer[/font]
[font="]If you can help me in this matter[/font]
[font="]It Will Be most of the most Appriciate[/font]
[font="] [/font]
[font="]Regards [/font]
Hardeep