Excel get 5 digit number from a string in a cell.
It might be a postcode or whatever you can think of a 5 digit or any digit number.
=LOOKUP(2,1/(MMULT(0+(ISNUMBER(-MID(" "&H95,ROW(INDIRECT("1:"&LEN(H95)))+{0,1,2,3,4,5,6},1))+0={0,1,1,1,1,1,0}),{1;1;1;1;1;1;1})=7),MID(H95,ROW(INDIRECT("1:"&LEN(H95))),5))
