Extract 7 digits number from the string please

In Colomn A , we paste the chat messages, in which we need to find the job number (not less than 5 digits / not more than 8 digits) have marked in red for reference. If it so Row B needs to mark as Feedback please help me on this..

kindly look at the attached excel for more clarity.

Thanks

Can any of your job numbers ever start with 0 (zero)?

No, Never start with o (zero).

Does the following macro work correctly for you? I ask because it identified more "job numbers" than you marked in your sample; so either you stopped marking all of the job numbers or I do not understand something about how you want to filter them.

Please Login or Register  to view this content.