Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup function/sum function | Excel Discussion (Misc queries) | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Get Column Letter from Column Number | Excel Worksheet Functions |