one way:

Choose Data/Text to Columns. Select the Delimited radio button and
choose Next. Enter a hyphen in the "Other" field, then click Finish.




In article ,
"baju" wrote:

Many numbers in one cell separated by hyphen. How to put them in separate
rows of one column?