I would say the quickest way is to select the column and
do Data Text to Columns, using "-" as your delimiter.
Then select the data, copy it, and Edit Paste Special
Transpose.

HTH
Jason
Atlanta, GA

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

.