extracting numbers from free form text field

L

landmark

Thanks Frank et al, I copied the formula but it is still not working.
Coming up with #N/A. :confused
 
F

Frank Kabel

Hi
first you ahve to enter this formula as array formula with
cTRL+SHIFT+ENTER. Also don't forget do define the 'seq' name
 
Top