LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default converting question; function, formula, or coding?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function/Formula Question John Morgan Excel Worksheet Functions 5 May 8th 08 08:09 PM
visual basic coding question stevie888 Excel Discussion (Misc queries) 0 November 26th 06 10:24 PM
Formula/Function Question JD01904 Excel Discussion (Misc queries) 2 November 25th 05 03:01 AM
if then statement color coding (or another function???) hopeful in jersey Excel Worksheet Functions 2 June 18th 05 07:49 AM
Formula Color Coding Andrew Excel Discussion (Misc queries) 5 March 25th 05 08:41 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"