Fill down a column using right(), skipping rows, VBA

[Lifeseeker]

Hi there,

I have a column that contains texts. Please see the attached file.

What I would like to do

1) In col B, starting at B2, I need to use the =right(A2, 5) to extract only the 5 digit number from all the FC rows
2) fill down the column B

The difficulty is that....the "text" argument in the =right() must be ONLY in the FC rows. (basically the 5 digit number needs to be put right beside each primary account, as shown in the sample file)

How shall a macro easily help me do the job?

Thank you

[Richard Buttrey]

Hi,

You don't need a macro.

One way with a standard excel function is
=IF(LEFT(A2,2)="FC",RIGHT(A2,6),B1)
in B2 and copied down

Regards

[Lifeseeker]

ah......I see I see......

I wonder why I didn't think of that!

Thank you!