finding a number within a text and numbers for multiple rows

  • Thread starter Thread starter Darshan
  • Start date Start date
D

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
 
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
 
Back
Top