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.
Bookmarks