5-digit

I have a string which will include text, numbers and punctuation. It's free text so it's never constructed in a consistent fashion. Within that string, there will occur 4x 5-digit integers. Sometimes the integer will be preceded by a space or a symbol (like " 12345" or ":12345" or "-12345" etc)...

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...

Hi, I have the following code to print page 1 of any worksheet with a 5-digit name For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then ws.PrintOut from:=1, To:=1 End If Next ws However, is it possible to change this code (again for any sheet with a 5-digit name) to print...