finding a number within a text and numbers for multiple rows
 

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

finding a number within a text and numbers for multiple rows
 

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

--
Gary''s Student - gsnu200820

finding a number within a text and numbers for multiple rows
 

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

--
Gary''s Student - gsnu200820

finding a number within a text and numbers for multiple rows
 

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" wrote:

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

--
Gary''s Student - gsnu200820

finding a number within a text and numbers for multiple rows
 

=MID(A1,FIND("_",A1,FIND("_",A1,1)+1)+1,4)
--
Gary''s Student - gsnu200820