Select the entire column.
Go to Data|Text to Columns and select Fixed Width radio button.
Click Next and in the white area, click just before the 5th last digit
in one of the numbers. You should see a vertical line separating the
numbers. You can drag the line over if you missed the point of
separation.
Click Finish. The numbers should be separated into 2 columns. Now you
can delete or hide the unwanted column of numbers.
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=497176