Sort Contents Within A Cell and Maintain Spaces

[excel0030]

I found this content sorting thread - and it works really well for sorting; however, it is removing spaces from words. For example, If the original term (among 20-40 other terms) is "Active Lifestyle", after I alphabetize it using the code, it says "ActiveLifestyle"

Any help maintaining the complete integrity of the original text, including the spaces?

original thread here: http://www.excelforum.com/showthread.php?t=833503

I am using the Latest Office 365 Version of Excel

Thank you in advance.

[excel0030]

Never mind - this post is solved.