Easy way is using =CONCATENATE(prefix;originalcell ) If the prefix needs to change then possibly having the prefix in another column would be useful.
Have fun. /paul On 5/5/05, [EMAIL PROTECTED] <[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) > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
