Trying to find example

[theta]

Hi. I previously found an example that allow for alpha / numeric items to be sorted. It uses a helper column producing a sort key.

So column a may contain

A123BC
123BC
123AB

And it then produces a sorted column with a helper in between.

I believe it used CODE and REPT("aaa") in a special function

The sort key looked something like
5.89645
4.58694
8.51633

Cannot locate it anywhere on the internet, any ideas?

 

[theta]

Found it boys and girls. Jon von der Heyden :

http://www.mrexcel.com/forum/showthread.php?t=518138