what about the PM you sent me? The last one here has 4 characters (TCIA)

Details appear in a number of different ways e.g.
1.MEDIA VISION DE PA 2000679547,2000679548,2000685031,2000685031,200068 5031 SKY
2.SVERIGESTELEVISIOLBC64745/01AGRREF810130423100000835
3.AVJET INTERNATIONA INV NO.TCIA12539/01 TCA12540/01TCI12538/01
I'd like to be able to return the following..
1. 2000679547 2000679548 2000685031 2000685031 2000685031
2. LBC64745/01
3. TCIA12539/01 TCA12540/01 TCI12538/01

I'd just love one excel formula to return the following results if possible

Can anyone help?
Cheers
Larkspur