| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data
Is there a script that can concatenate and replace all columns D and to column F and then move this into a new column D? Thanks very much, Robert. _EXAMPLE__ (-Data in columns D and E could also be alpha-numeric, bu will always be matched at the same comma points-) A..........B........C.............D.............E. ................F......... text....text....text.........1, 2.........3 , 4.............1(3), 2(4) text....text....text.........1.............4...... ............1(4) text....text....text.........1.............6...... ............1(6) text....text....text.........1, 6.........7 , 4.............1(7), 6(4) text....text....text.........1, 8.........9 , 4.............1(9), 8(4) text....text....text.........1.............10..... ...........1(10) text....text....text.........1, 10.......11 , 4...........1(11), 10(4) text....text....text.........1, 12.......13 , 4...........1(13), 12(4) text....text....text.........1.............14..... ...........1(14) text....text....text.........1.............16..... ...........1(16 -- soni ----------------------------------------------------------------------- sonic's Profile: http://www.excelforum.com/member.php...fo&userid=2306 View this thread: http://www.excelforum.com/showthread.php?threadid=39562 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging data from 2 data excel sheets | Excel Discussion (Misc queries) | |||
| Merging Data | Excel Discussion (Misc queries) | |||
| Merging multiple columns of data into one column of data | Excel Discussion (Misc queries) | |||
| Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
| Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...? | Excel Programming | |||
Threaded Mode
