copy 1 letter/3 number alphanumeric only

[loudnoiseman]

Hi Everyone,

I'm trying to copy any occurance of (1) letter followed by (3) numbers from column A over to column B.

For example, if in cell A99 the text is: (R451--Master#1 - Reel 2), then B99 should read: R451

I appreciate the help!!

 

[a7n9]

Enter in B99 : =LEFT(A99,4)

 

[loudnoiseman]

what if R451 occurs in the middle or at the end of the text?

 

[Scott Huish]

If you download the MOREFUNC add-in available here:
http://xcell05.free.fr/english/index.html

then perhaps:
=REGEX.MID(A1,"[A-Z]\d{3}")

Book1
	A	B	C	D
1	R451--Master#1 - Reel 2	R451
2	Master#1 - Reel 2 - Q927	Q927
Sheet1