I want to extract a number from a variable text string, ie the number is not
in a fixed position in the text string.

I want the numbers to be placed in a separate column so I can calculate the
median of the series.

E.g.
SB 118 Kenny St BV 6rm $415,000 Stockdale & Leggo Gladstone Park

should return the number 415,000

repeat for each row in the spreadsheet.

Any help appreciated.