How to concatenate adjacent cells in a range without using &?
Ark wrote:
I would like to know if there is a way to concatenate multiple cells in a row
without having to use concatenate with "," or "&" ?
i.e. is there something like concatenate(A1:F1)?
Yes there is a function if you prefer. Syntax is CONCATENATE(A1,B1,C1) not A1:
C1
But you'll find using & a lot quicker
|