Parsing data

[meppwc]

I have the following data in column D

11300-117-24001012 I need to separate the numbers into columns E, F and G, but without the dash and any spaces before or after the dashes. How would I accomplish that?

 

[Rick Rothstein]

Select the columns, call up the Text To Columns dialog box (Data tab, Data Tools panel), choose Delimited on first dialog page and specify the dash as the delimiter in the Other checkbox (make sure to set output to the correct beginning column).