Sorting numbers within cell

		Microsoft Office Forums > Microsoft Excel > Excel
Sorting numbers within cell

FAQ

Thread Tools

Display Modes

04-22-2017, 10:57 AM

Logit

Windows 10 Sorting numbers within cell

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Code:

Ascending : =TEXT(SUM(SMALL(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),ROW(INDIRECT("1:"&LEN(A1))))*10^(LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))))),REPT("0",LEN(A1)))

Descending : =TEXT(SUM(LARGE(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),ROW(INDIRECT("1:"&LEN(A1))))*10^(LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))))),REPT("0",LEN(A1)))

Paste formula, then press CTRL / SHIFT / ENTER at the same time.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.)	roderh	Excel Programming	4	09-02-2016 05:12 AM
Sorting Numbers in a Document	rsrasc	Word VBA	3	01-04-2016 11:47 PM
Sorting Index According to Page Numbers	mohsen.amiri	Word	14	06-25-2015 09:50 PM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
Sorting paragraph numbers	CommDude	Excel	1	01-02-2011 04:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:52 PM.