automatically enter alphabetically

[8} geo]

I would like to have a box to enter a [ xxxx 123 ] afew letter with numbers
and have it go in columns..... i have Excel & Word
aa 1 26
aab 1 23
aab 1 26
aabb 1 23

there will be 2 to 4 letters and 3 to 4 numbers ... i would think i need
Excel
to do this .... thk's to all the help.... 8}

 

[Jeff Boyce]

You've posted in a newsgroup dedicated to Microsoft Access, the relational
database product. Try posting in an Excel-focused 'group.

(By the way, using two separate fields would let you sort in the manner you
described.)