Splitting string based on case

[omnivl]

Hi
Im a bit stuck on this one, i need to split a string based on a lowercase hitting an uppercase for example:

Data
Sam JonesPaul SmithEvan Angus WalshJon Smith

Output
Sam Jones;Paul Smith;Evan Angus Walsh;Jon Smith

I have the data in column D and there will be 50000 + rows

 

[omnivl]

Thanks everyone, apologies for not replying sooner, the dreaded seasonal flu took hold (im located in Australia).
@Peter_SSs - i never gave thought to the last name issue, your solution has provided a 99.5% hit rate though only a few i have to manually correct

Appreciate the time everyone put in, it has saved some sleepless nights for me

 

[Peter_SSs]

i never gave thought to the last name issue, your solution has provided a 99.5% hit rate though only a few i have to manually correct

That sounds not too bad to me.
However, if you have to be doing this more times in the future, it might be worth posting a few examples (& expected results) where the code fails. You never know, perhaps an even better solution may turn up.

 

[Rick Rothstein]

That sounds not too bad to me.
However, if you have to be doing this more times in the future, it might be worth posting a few examples (& expected results) where the code fails. You never know, perhaps an even better solution may turn up.

I think the failure will happen for first names that have the lower/upper case embedded within them; for example, the first name MaryAnn. I'll be surprised if there is a way to handle them and also provide for last names with the lower/upper case embedded within the as well.