I want to CONCATENATE two cells. This is the formula I am using.

=CONCATENATE(B2," ",C2)

How do I do this formula by keeping the B2 Constant. So it looks like this, without me changing it:

=CONCATENATE(B2," ",C2)

=CONCATENATE(B2," ",C3)

=CONCATENATE(B2," ",C4)

=CONCATENATE(B2," ",C5)

Thanks