Parse Address using RegEx

[JennyRuns24]

Hello,

I have addresses that are both numeric and text, as well as some that are only text. How can I break this down so that I have numbers in one field and text in the other? And how do I put "Virtual" in the same column as "Highlands Pkwy SE" and so on? How do we also account for streets with numeric data? Is this doable? Can someone provide the RegEx expression to achieve this?  

Thank you

[DataNath · Accepted solution]

Hey @JennyRuns24, is this how you want them split? Or do you want the streets with numeric parts handled differently?

[binuacs · Accepted solution]

@JennyRuns24 One way of doing this

[JennyRuns24]

Thank you!!

[JennyRuns24]

Thank you!