Adding a letter to the beginning of each part number of a column

[Guest]

I am trying to import a huge list of part numbers from an Excel spreadsheet
to our item list in our accounting software, and we like to preceed each part
number by a 2 letter designation that tells us who our supplier is. Example:
Techniks supplies toolholders for us. One of their part numbers is 21003,
and all of them are purely numeric. I need to preceed each of about 2000
part numbers from this excel spreadsheet they have provided us with TK for
Techniks so the part number would be TK21003.

Any easy ways to get this done. I will probably need to make a helper
column, but that's fine. I appreciate any suggestions.

Brian Denny

 

[Guest]

let's say we have 21003 in cell A1. In an available (helper) column enter:
="TK" & A1 and copy down.

There you are.

 

[Guest]

How cool is that! Wow, inside of two days I have answered all the questions
riddling my mind with no time to figure out in all this Excel stuff. All of
you guys are great!

Brian Denny

 

[Dave Peterson]

If you have to preserve leading 0's:

="TK" & text(a1,"00000")

And copy down.

 

[Guest]

Thanks for the additional information. I really appreciate your help!

Brian Denny