Macro to extract 10 digit number from cell starting with 501

[amandeep08]

Hi All,

I want a Macro that will extract 10 digit number from cell which contains number & alphabets and the number should start from 501. The macro will override that cell with the number and .xlsx

Can someone pl help me

 

[Peter_SSs]

Hi,
I'm looking for an Excel that is able to extract all consecutive 5-digit numbers from each cell, separating the results with a comma.
Note while extracting, exclude numbers less than 5 digits, exclude numbers more than 5 digits

Duplicate to Help with Consecutive 5 Digits Number Extract Function

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.