copying many entries from one cell to many cells

[ImplodedBrain]

I have many numbers in one cell, but I need to put each of these numbers in their own cell, in a column. It sounds very simple, but I have alot to so I tried writing a macro to do it and I couldn't. Any suggestions?

 

[Andrew Poulsom]

Have a look at Data, Text to Columns on the menu.

Backup your workbook first!

 

[Sir Vili]

Hi ImplodedBrain.

Check this link also:

http://www.mrexcel.com/board/viewtopic.php?topic=20924&forum=2&1

BRGDS Sir Vili.