| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Numbers to Text with a Source Code list
Have you checked out Data - Text to Columns... To split out your numbers?
-- HTH... Jim Thomlinson "Kyle" wrote: I have a column of data with numbers relating to specific industries. Each row corresponds to an individual and their affiliated industries. Some cells contain 1 number and some contain several (separated by commas). I would like to break this column apart into each individual industry for separate columns. The corresponding person would have an x in the column that refers to the industry they relate to. I have a separate sheet for what each code (number) means. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Numbers to Text with a Source Code list | Excel Discussion (Misc queries) | |||
| convert text string to a number code | Excel Discussion (Misc queries) | |||
| Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
| convert numbers to alpha code | Excel Discussion (Misc queries) | |||
| Convert text strings to a code or number | Excel Worksheet Functions | |||
Linear Mode
