[EMAIL PROTECTED] wrote:
WE HAVE A SPREAD SHEAT WITH PART NUMBERS AND WOULD LIKE TO ADD A VENDERS PREFIX TO THE NUMBERS.IS THERE A FORMULA TO ADD A TWO DIGIT PREFIX TO A NUMBER?WE HAVE OVER 5500 PART NUMBERS. EXAMPLE ADD SI TO 5-155(SI5-155)
If you use the conctinate function you can join the text from 2
different cells into 1 new cell
So put your suffix in a new coll. and then concatenate them.
Doug Stewart
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
