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.