Decoding Part number entries for all values embedded
 

Austin
One way:
Use VLookup formulas in each of the columns. You would need tables (put
them in a hidden sheet) of what numbers correspond to what specifications.
You would use the Left, Right, and Mid functions in the VLookup formulas to
pick out the numbers to search for in the tables. Of course, all this would
be predicated on the user inputting valid numbers. A macro might be in
order here to check the user input for validity.
Would this be a one line thing for the user to find the specs of one 15
digit code, or would this be a long list of 15 digit codes and the user just
adds one more each time? The reason for this question relates to file size.
A long list with all formulas (except the first column) would get big in a
hurry. A long listing would work better if macros were used.
If you wish, send me, via email (remove "nospam" from my address) a
small file giving all the specs and corresponding numbers as well as some
sample 15 digit codes. I'll work up something and we'll see if it works for
you. HTH Otto


"Austin" wrote in message
...
I am trying to create an excell spreadsheet that will take
a coded input...for example, a company codes their
resistors by puting a 15 digit name on it...the first 5
specifying a quality of the resistor....the next 1
specifying its voltage rating, the next 2 specifying its
resistance and resistance tolerance etc. I want to have
users be able to enter this 15 digit code, and have excell
spit out all the different columns showing what the
different specifications of the part are. If anyone knows
how to do this...short of writing some C code...let me
know!!!

thanks...Austin