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!