I have a list that I want to sort on the first 10 digits- a cost center number- but some of them have additional characters at the end- CS- to be exact. So I want 4046750000 and 404675000CS to appear one after the other but instead the ones with the alpha ending get sorted to the bottom.
Figure there must be an easy fix- could someone clue me in?
This would actually be the 2nd level of the sort with the first level being a last name.
Thanks!
Figure there must be an easy fix- could someone clue me in?
This would actually be the 2nd level of the sort with the first level being a last name.
Thanks!