In A1 Cell
Text text text bla bla ##200100

In B1 Cell
Formula: copy to clipboard
=IFERROR(MID(A1,FIND("#",A1)+2,FIND(" ",REPLACE(A1&" ",1,FIND("#",A1),""))-1),"")