*-Go to Data menu, and choose text to columns. If you want it kept as
you see it, choose fixed width. If you choose comma delimited, it will
assign columns for each field. Choose how you want it allocated, it
will give you a preview, if that is how you want it click FINISH.-*
--
mrsinnister
------------------------------------------------------------------------
mrsinnister's Profile:
http://www.excelforum.com/member.php...o&userid=32737
View this thread:
http://www.excelforum.com/showthread...hreadid=525715