distinguish winning numbers from a given sentence

[aaaaa34]

Hey my friends,
In results page of loto results in one websites, winning numbers are placed in a sentenced with commas.
While i am copying them to excel, I want to have each number in cells along the row.
Sometimes while copying start of sentence, i don't copy every time from same point so formula should pay attention to it.
Can we distinguish these numbers and place them into seperate cells as it's shown in the worksheet?
Please have a look to the file. https://jmp.sh/sX6akuN
Thank you.


P.s: if i had to place this post under Formulas section, please sorry me. It can be moved.

 

[aaaaa34]

Sorry, I see no need for that. It is just 3 lines of code to copy from the forum and I have given step-by-step instructions of what to do.

What I do here wrong while inserting the colde? Because after i save as *.xlsm and press ALT+F8, macro is not appearing in the popup window

 

[Peter_SSs]

What I do here wrong while inserting the colde? Because after i save as *.xlsm and press ALT+F8, macro is not appearing in the popup window

My step-by-step instructions did not mention pressing ALT+F8. Instead ..

5. Enter the formula as shown in the screen shot below and copy across and down.

Have a look back at post 6 and in particular the function for entry into cell C1 shown under the second screen shot.

 

[aaaaa34]

My step-by-step instructions did not mention pressing ALT+F8. Instead ..
Have a look back at post 6 and in particular the function for entry into cell C1 shown under the second screen shot.

yes, you're right. code runs perfectly with formula written on C1 cell. Thank you, Peter.

 

[Peter_SSs]

yes, you're right. code runs perfectly with formula written on C1 cell. Thank you, Peter.

Cheers. Glad you got it sorted. Now you have a choice.