Add space between a number and text

[hash_89]

I need to do some cleanup of the address to add space between them.  I was able to add space before every upper case. however, in some places there is a lower case.  How can I add space after the numbers?

left is how the data looks like. Right side is what I want it to look like.

111111mooersAve	111111 mooers Ave
2222WatershedDrive	2222 Watershed Drive

Thanks

[binuacs]

@hash_89 one way of doing this

[nagakavyasri]

@hash_89 One way of doing this:

[CoG]

More dynamic approach using the RegEx Tool (that handles both conditions - and can be configured to handle more):

Hope this helps and Happy Solving!