Select your column - then go to Menu Bar - and Select Data - Text to
Columns and follow the instructions - this will put your data in
Columns A and B - then just copy column B and paste below column A. If
the numbers need to be in a particular order Copy your Column A - Open
WORD and Paste.
Then select the column - then on the MENU Bar - Select TABLE - CONVERT
- TABLE to TEXT.
Then in the Find and Replace Box - In the FIND enter /
In the REPLACE - enter ^p - This will separate all of your number and
put them one below the other.
Then COPY and PASTE back into EXCEL and you will be done.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=520592