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

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

There you are.
--
Gary's Student


"Brian Denny" wrote:

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

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

"Gary''s Student" wrote:

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

There you are.
--
Gary's Student


"Brian Denny" wrote:

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

If you have to preserve leading 0's:

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

And copy down.

Brian Denny wrote:

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

--

Dave Peterson

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

Brian Denny

"Dave Peterson" wrote:

If you have to preserve leading 0's:

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

And copy down.

Brian Denny wrote:

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

--

Dave Peterson