Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Sorting mixed alpha and numeric cells (#mixed)
Posted by - NA - on 21 March 2006 06:11 AM
|
|
|
Problem: want to sort mixed text and numbers as if text Solution: Create a helper column, use to following formula and fill down, then sort on the helper column. =IF(ISBLANK(A1),CHAR(255), IF(ISTEXT(A1),A1,TEXT(A1,"@"))) | |
 (159 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)