Hope I can get some help with a problem I´m trying to solve since days ago. I apologize if this has already been asked, but I could not find any post addressing this situation.
What I have is a long alphanumeric string, and need to extract from it, all number in a row of 6 digits, showing them separated by ",", or ";".
Find below an example:
A1= "SSA REF.NNF S/19 820707sometext822845/82068flkjsdf 822845/ "
Required result:
B1 = 820707;822845;822845
Thanks for your help, any dobt just let me know. thanks!
What I have is a long alphanumeric string, and need to extract from it, all number in a row of 6 digits, showing them separated by ",", or ";".
Find below an example:
A1= "SSA REF.NNF S/19 820707sometext822845/82068flkjsdf 822845/ "
Required result:
B1 = 820707;822845;822845
Thanks for your help, any dobt just let me know. thanks!