I have a spreadsheet lots of people have added to it so it's inconsistent
I'm trying to extract the batch number from each cell
The number always follow the word BATCH - but it can be at the end or start (sometimes very rarely the middle)
BATCH 498 - P1 PACKAGE - PUMPS - MEMBRANES
BATCH 495 - P1 COMPRESSION (HP) - TRANSMITTER
P2 CRITICAL SPARES - BATCH 494
P2 HEATER - BATCH 499
So for above I'd like a formula that will return;
498
495
494
499
I'm trying to extract the batch number from each cell
The number always follow the word BATCH - but it can be at the end or start (sometimes very rarely the middle)
BATCH 498 - P1 PACKAGE - PUMPS - MEMBRANES
BATCH 495 - P1 COMPRESSION (HP) - TRANSMITTER
P2 CRITICAL SPARES - BATCH 494
P2 HEATER - BATCH 499
So for above I'd like a formula that will return;
498
495
494
499