Skip to Content
0
Former Member
Feb 17, 2011 at 09:05 AM

Sorting an alfanumeric field

40 Views

Hello,

I have an alfanumeric field called Position. This field can have numeric and alfanumeric data, like:

1

2

2a

3

4

4a

4b

5

10

11

12

13

To get this sorted I created a formula totext ()

The result is:

1

10

11

12

13

2

2a

3

etc...

What should be the formula so I get the result as:

1

2

2a

3

4

10

11

12

etc...

Thanks,

Tim