Sort Unique Text Values In Cell Excel VBA Macro

In this video we see how to sort unique text values or words inside a single cell in the Excel worksheet using VBA macros. This may come handy when dealing with a bunch of text imported or scraped (also copy/pasted) into a single cell, which we may need to sort or handle in some way. The process consists of converting the text into an array that allows to count the number of words, sort the words in alphabetical order, and do other manipulations of the text such as extracting the words into a range of cells. The macro example is used to sort the text inside a cell alphabetically.

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga: