Hi, Have spent a bit of time on this, hope you can help.
Other answers on the web dont quite work for one reason or another.
i have alphanumeric numbers in a large dataset (dataset 1 is first)
3
5
10A
11B
12
15
99
123B
176
234
1056A
The 2nd dataset has leading zeros on them to aid with a data issue we had.
0003
0005
0010A
0011B
0012
0015
0099
0123B
0176
0234
1056A
Can I have some formulas thats sorts the 1st and 2nd dataset numerically, as shown in the preferred order above.
Can i also have formula's that can add and remove the leading zeros properly incl. the alphanumeric's.
im trying to join the two datasets back together and need a common join.
Thanking in Advance.
Other answers on the web dont quite work for one reason or another.
i have alphanumeric numbers in a large dataset (dataset 1 is first)
3
5
10A
11B
12
15
99
123B
176
234
1056A
The 2nd dataset has leading zeros on them to aid with a data issue we had.
0003
0005
0010A
0011B
0012
0015
0099
0123B
0176
0234
1056A
Can I have some formulas thats sorts the 1st and 2nd dataset numerically, as shown in the preferred order above.
Can i also have formula's that can add and remove the leading zeros properly incl. the alphanumeric's.
im trying to join the two datasets back together and need a common join.
Thanking in Advance.