| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP: Formula for combining fields
Can someone help me ? I have a CSV file which can be opened in Excel. The CSV file i comma-seperated ! Column 1 contains the cd numbers and column 2 contains the tracknumber and names So I do have a table with the following contents: 1,01;track1 1,02;track2 1,03;track3 2,02;track1 2,02;track2 And so on.... I want to have a formula, or result with the following contents: 1,01;track1|02;track2|03;track3 2,02;track1|02;track2 Is that possible to create ? How -- pollewop ----------------------------------------------------------------------- pollewops's Profile: http://www.excelforum.com/member.php...fo&userid=3399 View this thread: http://www.excelforum.com/showthread.php?threadid=53762 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining spread sheets with common fields | Excel Discussion (Misc queries) | |||
| Drop down selections and combining fields. | New Users to Excel | |||
| combining fields on a pivot table | Excel Worksheet Functions | |||
| Combining fields and outputting to one cell | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Threaded Mode
