Extract numbers from text into multiple columns

[Giraffe]

Thanks Rick for trying but assuming I have entered it correctly and run it correctly it came out as attached. At the moment I have spent most of this week writing a 50,000 line, 6 column look up table to try to cover every eventuality but this is a somewhat time consuming way and not fool proof, and this only solves one set of data and I have another 2 to solve, so if you can find a way I would be very grateful!