Hello,

I am looking to split hyphen-separated data into individual cells.

The data is formatted like this:

186.00000000 - 130.00000000 - 76.00000000 - 40.00000000
30.00000000 - 39.00000000 - 24.00000000 - 4.00000000
226.00000000 - 323.00000000 - 122.00000000 - 96.00000000
6.00000000 - 1.00000000 - 5.00000000 - 5.00000000

There is a space, hyphen, space between each number. Each number has eight decimal places, and an unknown number of significant digits. I would like to be able to extract each individual number into its own cell.

I played around with nesting SEARCH and LEFT, MID, RIGHT position functions with no luck. I think I was on the right track, but couldn't get it to work.

Any help is much appreciated.

Josh