Extract Numbers from the Middle of a Field

[cpalmer72]

I have a series of numbers in a column such as:

SR07-9879A
PCK MC79-2863B
RTN PP24-3894A
VA62-8933A1

I want to put a formula into another column which will return only the 2 digits left of the dash through the four digits after the dash:

07-9879
79-2863
24-3894
62-8933

I also need a column which will return only the letters before the space at the beginning (if any, see the "PCK" & "RTN" in the first list) and a column which will only return anything after the four digits after the dash (if any, results from the first list would be A, B, A, A1).

Please help! Thank you!

[berlan]

Try in cell A1,

=LEFT(REPLACE(A1,1,FIND("-",A1)-3,""),7)

and copy down.

Regards,
berlan

[berlan]

and as for the other 2 columns;

I also need a column which will return only the letters before the space at the beginning (if any, see the "PCK" & "RTN" in the first list)

=IF(ISNUMBER(FIND(" ",A1)),LEFT(A1,FIND(" ",A1)-1),"")

a column which will only return anything after the four digits after the dash (if any, results from the first list would be A, B, A, A1).

=IFERROR(MID(REPLACE(A1,1,FIND("-",A1)-3,""),8,255),"")

[cpalmer72]

Thank you SO much, berlan! All three worked perfectly!