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