Bit of a weird issue here.
I use a lot of alphanumeric data (not by choice) and need to sort them properly. It used to work flawlessly with the tips described on Microsoft support pages, here : http://support.microsoft.com/kb/322067. I used the TEXT(A1,"###") function.
Now, it will not work for reasons unknown.
Basically, I would need this :
2a
45b
6
3c
4
7a
11
46
43
To look like this :
2a
3c
4
6
7a
11
43
45b
46
But Excel sorts it like this :
4
6
11
43
46
2a
3c
7a
45b
There were no updates on our servers, and I use the same Excel version (2007) as before, so I'm really stumped. I tried it at home just for fun and it worked fine.
Anyone has an idea why the alphanumeric sort would suddenly not work ?
Thanks.
Bookmarks