Read More:How to Concatenate with Space in Excel Reason 3 – Passing a Range as an Argument in CONCATENATE Function TheCONCATENATEfunction doesn’t accept a range of cells as arguments. If you try to concatenate a range directly, it won’t work as expected. For instance, typing the followin...