How do I sort alpha neumeric fields that have an alpha suffix?

  • Thread starter Thread starter Bob Sparks
  • Start date Start date
B

Bob Sparks

Using Microsoft Excel How do I sort alpha neumeric fields that have an alpha
suffix?
 
well, in Access, values that are mixed alpha-numeric are always Text data
type. so numbers are treated as text, and get an ASCII sort, as

10
102
11
12
127
13

and alpha characters are sorted alphabetically as always. i believe Excel
uses the same logic to sort, but to be sure, suggest you post your question
to an Excel newsgroup.

hth
 
You can lose the sufix several ways --
CDbl([YourField]) convert to double
CInt([YourField]) convert to integer
Val([YourField])
 
Back
Top