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

B

Bob Sparks

Using Microsoft Excel How do I sort alpha neumeric fields that have an alpha
suffix?
 
T

tina

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
 
K

KARL DEWEY

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

Need help removing extra TOC text from number lists used as TOC levels 0
Booklet in Word, Merge Directory from Excel 0
Need help merging Excel into Publisher Booklet w 2 columns 0
Mail Merge Directory Conditional Page Break 0
How do I sort alpha neumeric fields that have an alpha suffix? 3
Importing Alpha-Numeric value into Access 3
What is this called in Excel or how it works? 0
field Null but not Null 9

Top