Arnold: You told us what it needs to look like at the end... but you
didn't tell us what the data looks like BEFORE. My best guess is the
use of concatenation and other text functions to construct your data
into the desire format.

More info, please...


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=373836