joining multiple cell contents into single string

  • Thread starter Thread starter Julz
  • Start date Start date
J

Julz

Good morning,

Am needing to join together cells into a single cell, seperating each
with a comma.

a b c d e f
1 text 123 5 text text text,123,5,text,text
2 576 543 21 text 0 576,543,21,text,0

any assistance is greatly appreciated.

thanx!
~julz
 
Hi

One way:
=CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1)
or
=A1&","&B1&","&C1&","&D1&","&E1
 
Back
Top