separating multiple Proper names (uppercase letters) from a list

[Keebler]

I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into adjacent cells...
ex:
Jim BobJo JamesMike PettersonDirk Smith Jim Bob Jo James Mike Peterson Dirk Smith

Jim BobJo JamesMike PetersonDirk Smith

Jim Bob

Jo James

Mike Peterson

Dirk Smith

does that make any sense?

thank you
Ken

to add injury to insult.. there are a few times that I have seen Proper names with McFlury or people with 2 last names Like JoEllen Smith-Peterson

thank you

 

[Keebler]

that what was causing the 3rd name to not populate.. the second space... removing it solved the issue
AND the module is called module 1

so, NOW BOTH the formula AND the function are working... thank you SO VERY much for all your time and expertise
thank you and Merry Christmas

 

[Peter_SSs]

removing it solved the issue

.. or not sure if you saw my last post which should take care of any multiple spaces in the data.

so, NOW BOTH the formula AND the function are working...

.. but with the possible issues raised early in the thread of course.

 

[Keebler]

I went ahead and added the extra line thank you again

 

[Keebler]

so, how do I mark this SOLVED

 

[Peter_SSs]

You're welcome.

so, how do I mark this SOLVED

We don't do that in this forum, but see here

 

[Peter_SSs]

so, how do I mark this SOLVED

You're welcome.


We don't do that in this forum, but see here

I noticed that you marked post #16 as the solution. That post definitely does not contain a solution to your question so I have unmarked it. If you are going to mark anything it should be the post that answers the question and best suits your needs.