Thanks guys for your help.

While I was waiting I finally got my version to work with

=IF(LEFT(A2)="S",CONCATENATE("ST",B2),IF(LEFT(A2)= "K",CONCATENATE("LO",B2),IF(LEFT(A2)="B",CONCATENA TE("BS",B2))))

Keep up the good work

GLW


--
glwday
------------------------------------------------------------------------
glwday's Profile: http://www.excelforum.com/member.php...o&userid=32336
View this thread: http://www.excelforum.com/showthread...hreadid=520976