Hi

Select the columndataText to ColumnsDelimitedOther enter a hyphen as
the delimiterFinish
You will have 2 columns of numbers.

--
Regards
Roger Govier

"quynies_mom" wrote in message
...
I have a worksheet with a column of sortof numbers: 1-25, 76-100,101-150,
901-1000, 1001-1100. I want to separate the number into 3 columns with
the
first number, the dash and the last number. I can do it a line at a time
but
it would be good to have a formula that would work for all the numbers.

Thanks.