View Single Post
  #3   Report Post  
GRM via OfficeKB.com
 
Posts: n/a
Default 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