Extract Numbers from a cell

Hi Team,

I have a data like below


Column
LS NO : 789 P 1
LS 46 SANDESARAPATI
SANDESAR PATY SU.242/2
LSNO-581 AG BOREWELL
L S NO:-189-9727751605
L.S. NO-1249/18P1,KHANDOSAN
23 Long Street

I need to extract number values as below

Required
789P1
46
242/2
581
189 (next is mobile number it should not come)
1249/18P1
BLANK

so far I have tried this equation and I am failing to achieve the target

=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"SU","LS NO","L S NO","L.S","SURVEYNO","LSNO:","LS","L S No","LSNo"},C5)))>0,SUMPRODUCT(MID(0&C5, LARGE(INDEX(ISNUMBER(--MID(C5, ROW(INDIRECT("1:"&LEN(C5))), 1)) * ROW(INDIRECT("1:"&LEN(C5))), 0), ROW(INDIRECT("1:"&LEN(C5))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(C5)))/10),"")

using the above it is mixing all the numbers together, is there possibility to keep two separate number series ?

Hope to get a response soon.
Thank you in advance!

Try this with ctl+shift+enter
=LEFT(MID(A1,MATCH(TRUE,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&(LEN(A1)))),1)+0),0),MATCH(2,1/--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),1)),MATCH(2,1/--ISNUMBER(--MID(MID(A1,MATCH(TRUE,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&(LEN(A1)))),1)+0),0),MATCH(2,1/--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),1)),ROW(INDIRECT("1:"&LEN(MID(A1,MATCH(TRUE,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&(LEN(A1)))),1)+0),0),MATCH(2,1/--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),1))))),1)),1))