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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort alpha neumeric fields that have an alpha suffix? 3
Importing Alpha-Numeric value into Access 3
field Null but not Null 9
Corsair Carbide Spec-Alpha Case 1
remove letters from an alpha-numeric field 3
Excel Excel IF variable based on time of day 0
Labels printing in alphabetical order! 1
Linking Alpha 4 database 6

Back
Top