Help with Consecutive 5 Digits Number Extract Function

[pomamo]

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

 

[Zot]

You will find solution you like here I believe

Extract multiple 5-digit numbers from alphanumeric text

Hello, I need to extract multiple 5-digit numbers from a cell that contains both letters and numbers. I found a thread that solves for how to extract a single number but this doesn't work for me because my data might contain multiple 5-digit numbers. Here is an example of how my data looks...

www.mrexcel.com

 

[pomamo]

Thank you hi definitely work