Seperating numbers on 1 cell to multiple cells

jorgearielzetina

New Member
Joined
Sep 9, 2009
Messages
1
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

Legend
Joined
Jun 19, 2002
Messages
63,651
Hello and welcome to mrExcel.

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

Forum statistics

Threads
1,085,565
Messages
5,384,469
Members
401,903
Latest member
MarBer

Some videos you may like

This Week's Hot Topics

Top