so here's the function.....

=if(RIGHT(B1,2)="11","J",if(RIGHT(B1,2)="12","J",i f(RIGHT(B1,)="13","J",
if(b1=id021,"a",if(b1=xd021,"A",if(RIGHT(B1,2)="20 ","b",,if(RIGHT(B1,2)=
"21","B",",if(RIGHT(B1,2)="22","B",if(b1="ib031"," D",if(b1="id054,"D",if(b1=
"me031","d",if(b1="mb031,"D",if(b1="yb031,"D",if(b 1="yc031,"D",if(b1="xd031,
"D",if(b1="xc031,"D",if(RIGHT(B1,3)="031","E",if(R IGHT(B1,3)="032","E",
if(RIGHT(B1,3)="041","E",if(RIGHT(B1,3)="042","E", if(RIGHT(B1,3)="051",
"C",if(b1=db052,"g",if(RIGHT(B1,3)="053","c",if(RI GHT(B1,3)="054","D",if
(b1=db055,"g",if(RIGHT(B1,3)="061","E",if(RIGHT(B1 ,3)="062","E",if(RIGHT
(B1,3)="071","E",if(RIGHT(B1,3)="072","e",if(RIGHT (B1,3)="080","I",if(RIGHT
(B1,3)="081","I",if(RIGHT(B1,3)="082","I",if(RIGHT (B1,3)="083","I",if(RIGHT
(B1,3)="084","I",if(RIGHT(B1,3)="085","I",if(RIGHT (B1,3)="086","I",if(RIGHT
(B1,3)="087","I",if(RIGHT(B1,3)="088",if(b1=db122" ,"B",if(RIGHT(B1,3)="121",
"a",if(RIGHT(B1,3)="123","A",if(RIGHT(B1,3)="221", "B",if(RIGHT(B1,1)="l","N",
if(RIGHT(B1,1)="r","n",if(b1="hd981","I",if(b1="id 981","I",if(RIGHT(B1,3)=
"081","G"))))))))))))))))))))))))))))))))))))))))) ))))))

the value in B1, will be any of the following and more.....
HB011,HB021,HB031
HB041,HB051 something like that..... we have about 300 part numbers
that i have to be able to use the last 3 characters to know what part
CODES they are. the first two letters indicate the year and model, and
the last three numbers indicate which part, and for what application. it
appears however that a cell can only hold 255 charachters or so and i
can't fit my function in there.

if not the function, or some code, how can i get all this done?


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=501427