Hi,

Your approach could lead to nonunique values upon conversion - e.g.,
AQM1111M, LBM1111M, and LUC111M will convert to the same number 12213111113.
However, you could transform the alphanumerics to unique numbers using ANSI
codes, with some limitations.
Are all the strings of the same format (i.e., 3 letters-4 numerals-1
letter), and are the letters always in capital case? If yes, the following
formula will generate unique numbers for the strings.
=CODE(LEFT(A1,1))&CODE(MID(A1,2,1))&CODE(MID(A1,3, 1))&MID(A1,4,4)&CODE(RIGHT(A1,1))
If there are lower case letters and/or your strings do not have one common
format, a more elaborate(!) formula is needed.

Regards,
B.R. Ramachandran


"SDesmond" wrote:

I have a series of alphanumeric numbers (ex. CIS9638S) that I would like to
automatically convert to a numeric string (ex. 3919963819) that need continue
to be unique values. Is there a script or function that will convert alpha
characters to a numeric representative?