Problem description & analysis

Here is an Excel file Book1.xlsx:

Column A contains strings of numbers We are trying to perform distinct on each number, sort it, and enter results in column B. Below is the expected result:

Solution & explanation

First, we load add-in ExcelRaq.xll, and then

Select cell B2, enter the following formula: =esproc("=string(int(?1)).split().id().concat()",A2)，, and drag the cell down to B6 to get results.

Q & A Collection

https://stackoverflow.com/questions/63540928/divide-numbers-into-unique-sorted-digits-displayed-in-a-label-on-a-userform