copy 1 letter/3 number alphanumeric only

loudnoiseman

Board Regular
Joined
Dec 31, 2004
Messages
196
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!!
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,118,110
Messages
5,570,250
Members
412,313
Latest member
pauloalex
Top