Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am importing a spreadsheet with two columns; ID and Code number.
I want to convert these into readable text. Each combination (about 90 potential combinations) of ID and Code renders unique text. What is the best way to convert the data? Should I use a function, read another table, etc. For example: ID Code Company Part Combined 10 100 ACME widget ACME widget 10 200 ACME cog ACME cog 10 300 ACME sprocket ACME sprocket 20 100 Bell Mfg wrench Bell Mfg wrench 20 400 Bell Mfg cog Bell Mfg cog 30 600 Zebra Dist bucket Zebra Dist bucket |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function/Formula Question | Excel Worksheet Functions | |||
visual basic coding question | Excel Discussion (Misc queries) | |||
Formula/Function Question | Excel Discussion (Misc queries) | |||
if then statement color coding (or another function???) | Excel Worksheet Functions | |||
Formula Color Coding | Excel Discussion (Misc queries) |