Help with Data Extraction

[Bparker23]

I have searched the forums and I probably am using the incorrect verbiage, but I was unable to find the solution for what I need. I apologize if this was previously asked. I need to extract all "numbers" where number of characters = 5 or 6 and place them in individual rows in a single column.

Example:

Lets say this is Column A

TICKET: 82705, 82707 TRANSPORT HAULED 150BBLS FW FROM YARD TO LOCATION & 150BBLS...

TICKET: 82810 TRANSPORT HAULED 150BBLS FW FROM ED POND TO LOCATION DRIVER: DK TRUCK...

TICKET: 83117 DRIVER: SB TRUCK: 23

TICKET: 82710, 82712 TRANSPORT HAULED 300BBLS FW FROM ED POND TO LOCATION DRIVER: FK...

TRANSPORT HAULED 120BBLS OF FRESH WATER TO. TICKET: 82072 DRIVER: CH TRUCK: 16

TICKET: 200703, 200865, 200866, 200881, 200883, 200919 TRANSPORT HAULED 880BBLS...

What I would need to see displayed in Column B needs to be:

82705
82707
82810
83117
82710
82712
82072
200703
200865
200866
200881
200883
200919

How would I accomplish this? The above is an example showing the erratic locations. I am currently manually keying this out by hand which is taking over 15 hours to do . Any help would be appreciated.

[rylo]

Hi

Try this.

Please Login or Register  to view this content.

rylo

[Bparker23]

This appears to have worked like a charm!

Thank You Rylo!