Extract multiple numbers from a text string???

Hi there, basically i have a text string with text and multiple numbers at different character positions in a cell. I need to extract these numbers only, doesnt really matter in what format as long as i get ALL the numbers in another cell. A sample of a typical cell is below:



363 - which station poster232 - cab tube179 - inter car barrier188 - control key replaced893 CAB LIGHT TUBE340 LIGHT TUBE111 LIGHT TUBE

i want all the numbers within this text string.

I have previously used the following custom formula to extract the numbers but that only works to extract the first 15 numbers and then for the remaining numbers it just returns 0's, although they are the exact amount of zeros as are the exact amount of numbers left in the string.

Please Login or Register  to view this content.

The result that i get with this formula is 363232179188893000000

this is not what i want, i want all the numbers.


Anyone any help please?? what am i doing wrong here?

Thanks

Change the function to return a string instead of a double

Please Login or Register  to view this content.

Another way:

Please Login or Register  to view this content.