How to sort numbers within a cell

		Microsoft Office Forums > Microsoft Excel > Excel
How to sort numbers within a cell

01-27-2022, 10:14 AM

p45cal

Windows 10 How to sort numbers within a cell

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

Code:

=TEXTJOIN(",",TRUE,SORT(FILTERXML("<t><s>"&SUBSTITUTE(A1,",","</s><s>")&"</s></t>","//s")))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sort/select by duplicates containing cell colour	JamesTheNoob	Excel	3	04-08-2019 09:11 AM
Sort numbers in Ascending order	btserver	Excel	5	03-16-2019 07:54 AM
Cell references don't change on sort	gebobs	Excel	3	07-23-2015 05:14 AM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
Trying to autofilter 8-10 rows of numbers to sort in a group	Jack-P-Winner	Excel	0	11-25-2013 10:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:04 PM.