It may be user error, but I'm not 100% sure. I am trying to copy a Concatenate formula to about 800 cells. Column one needs to be merged with column two. I have =CONCATENATE(A1,B1). I copy that to highlighted cells but it will only go into the first cell, but use the information in A1 and B1 over again, which isn't what I want. Say I have a large selection of these items that need to be merged (I'm not doing them all at once, but in chunks), what would be a good concatenate formula for these? I would need A and B down to whatever row (let's just say 200). Attached is a sample sheet.

remussampler.xls

Any help and advice is greatly appreciated. Thank you!