Which number (there are three in your example):

118 ?
6 ?
425,000 ?
--
Gary''s Student - gsnu200783


"tipsy" wrote:

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.