btadams
Well-known Member
- Joined
- Jan 6, 2003
- Messages
- 1,943
Does anyone know of a formula that would sort a range of cells containing text. For example, I have the following in cells A1:A12
160605-B-094
160605-B-130
160605-B-026
160605-B-108
160605-B-031
160605-B-043
160605-B-078
160605-B-059
160605-B-068
160605-B-085
160605-B-012
160605-B-047
Is there a formula I could put in B1:B12 that would sort in order of the last three numbers:
160605-B-012
160605-B-026
160605-B-031
160605-B-043
160605-B-047
160605-B-059
160605-B-068
160605-B-078
160605-B-085
160605-B-094
160605-B-108
160605-B-130
Thanks,
160605-B-094
160605-B-130
160605-B-026
160605-B-108
160605-B-031
160605-B-043
160605-B-078
160605-B-059
160605-B-068
160605-B-085
160605-B-012
160605-B-047
Is there a formula I could put in B1:B12 that would sort in order of the last three numbers:
160605-B-012
160605-B-026
160605-B-031
160605-B-043
160605-B-047
160605-B-059
160605-B-068
160605-B-078
160605-B-085
160605-B-094
160605-B-108
160605-B-130
Thanks,