The concatenate operator (&) should work.
1. If column A contains the part numbers, starting at A1, then type the following into B1:
="SI"&A1
2. If column B is already used, select it, right click it, click "insert column" before doing step 1.
3. Click the lower right corner of B1, then drag down until the B column is filled as much as the A column.
4. Select all rows in column B, Ctrl-C, select column A, press Insert key on your keyboard (or right click, then Paste contents or whatever it's called, I use the Swedish version so I have to guess a bit here), deselect All and then make sure strings and numbers are selected and that formulas are deselected. Click OK.
5. Now Column B could be removed and column A contains the new part numbers.
Hope this is what you asked for.
In this case I only added SI as a prefix to everything. If you want to add not only SI, but different things all the time, then create two new columns instead of one, in this case columns B and C. Enter the prefixes into B. Enter the following into C1:
=B1&A1
Then follow steps 3-5 above, but do everything on column C that is said to be done for column B. In step 5, both column B and C can be removed.
If SI is supposed to be added for ALL part numbers, there is an even easier way to do it, IF the part numbers columned are not used by other cells in any way:
Select the A column, right click, format cells, enter "SI"@ to the format field. OK.
Now it LOOKS right, but the cells still only content the old part numbers. This is a quick solution, but may not be exactly what you were looking for.
-- Johnny
<[EMAIL PROTECTED]> skrev den Wed, 4 May 2005 13:39:15 -0400:
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]
