finding a number within a text and numbers for multiple rows

[Darshan]

i have the following text in

A1 Darshan_4875_09
A2 Jack_4888_09
A3 Johansson_8988_09
A4 AB_9900_09

I need to get in column B only the numbers i.e.

B1 4875
B2 4888
B3 8988
B4 9900

How do i get this

 

[Gary''s Student]

=MID(A1,FIND("_",A1,1)+1,4) and copy down

 

[Gary''s Student]

=MID(A1,FIND("_",A1,1)+1,4)

 

[Darshan]

sorry i think i did not give the full picture.

my file has this

A1 Darshan_RA_4878_09
A2 MA_RC_9900_09
A3 Johansson_AB_8800_09
A4 Mic_CC_8900_09

so i need to get in B1 (4878), B2 (9900), etc

currently your formula is not working

 

[Gary''s Student]

=MID(A1,FIND("_",A1,FIND("_",A1,1)+1)+1,4)