That's really helpful thanks, but the problem is that the space between
the two values isn't always in the same spot, and the text to columns
command looks like it needs me to specify where the break should occur.
The problem is that b/c it's not always in the same spot then it will
break words at times.


--
gemispence
------------------------------------------------------------------------
gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113
View this thread: http://www.excelforum.com/showthread...hreadid=568449