excelTrying to extract a number

excel - Trying to extract a number from a string and compare it to another number in a set of strings - Stack Overflow
I have the following set of data. In sheet A the data appears like "John D #23".In sheet B
admin8天前
50