I'm using a spreadsheet to input a series of digits into a particular cell. I want to be able to use formula 。

For example, I input the numbers: 21, 10, 37, 2, 5, 44 into cell A1; the numbers will be separted by a space not a comma (,).

After formula, cell B2 (or whatever cell) should show: 2 5 10 21 37 44. Please help!

if I input the numbers: 21,21, 10, 37, 2, 2,5, 44,37 into cell A1, the B1 should also cannot duplicated ，so should still be 2 5 10 21 37 44

Regards.

i use the url https://www.ozgrid.com/forum/forum/...298-sorting-data-numbers-within-a-single-cell

but the different is

1.to Remove duplicate numbers

2.use real formula not vba

3.if use VBA how to？

thanks a lot