Parsing A Number from An Inconsistent Note

Hello,

I've ran into a problem with a table containing thousands of notes for each of these accounts. Each note may or may not contain a 4-6 digit account number, and a 2-digit number for something else relevant. The rest of the data in the notes is irrelevant, but the format of the notes is completely inconsistent, and the numbers are not in any particular place.

Another complication is that the data imported containing line breaks into the cells, which I am not sure if I can remove ahead of time or at least work around. As a note, there are no line breaks in the numbers - they are all together. The 2-digit numbers are one of a specific list of numbers that I do have, so I can compare those and find those. The account numbers, however, are very difficult to find!

I've been working on a VBA macro to fix this, but I'm running out of time and I need to have it completed shortly so I am reaching out for any help I can get!

I apologize, but examples are not something I can provide as the information being sorted is confidential. I think I've provided an adequate explanation, but if something else is needed please let me know ASAP.


< There is a line break pasted directly before the arrow - in case that's needed.

Can you show us few dummy examples.

You can replace all alphabets with "x".

e.g

xxxxx xxxx 12345 12
123456 xxx 33 xxx xxxx

etc.