finding a number within a text and numbers for multiple rows

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top