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
Bookmarks