I have a bunch of messy addresses and trying to split them by single elements.

Already found the way of extract the street name but I need comma before each of them.

Beacuse some of them don’t have the comma before the street starts (or at least proper number of the street) I am unable to do it.

I found the solution here:

Add a comma after certain digits in Excel

but it seems like it doesn’t work in my case

  =MID(O2,1,2)&","&MID(O2,3,3)&","&MID(O2,6,4)&","&MID(O2,10,2)

as I have commas in random location instead of behind the numbers only.

Is there any way of how I could place the comma after the number in the string?