Seperating numbers on 1 cell to multiple cells

[jorgearielzetina]

Hello, I have multiple cells that contain 5 set of numbers that are separated by dashes. Example: 10-11-17-20-26

These set of numbers are on 1 cell only. Exp: A1

I would like to separate these numbers. I would like 10 to be displayed on A1, 11 on B1, 17 on C1, 20 on D1 and 26 on E1.

Is this possible? Note: I would not like to keep the dashes. I have over 1000 cells with different set of numbers. So I would like for the next row to be A2, B2, C2, D2, E2, and so on....

Any help would be greatly appreciated.

Thanks in advanced.

 

[VoG]

Hello and welcome to mrExcel.

Select the data, Data > Text to Columns > select Delimited and when prompted tick Other and enter - then click Finish

 

[Robert Mika]

Are you after something like that:
http://rapidshare.com/files/277850602/Split.xls