Pharse a word

[shyamvinjamuri]

I need to pharse a name into first name and last name based on upper and lower cases.
eg. JaneDoe I would like it to read Jane Doe

vba help please. I use excel 2007.

Thanks

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?p=2634702#post2634702


Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.