PDA

View Full Version : How to conjuct all the excel value into one cell?



clif
12-27-2016, 09:48 PM
Dear all,

cell A1 = 9-19
cell B1 = 10-19
.
.
.
.
cell Z1 = 5-21


cell AA1 = 9-19 10-19 . . . . . 5-21

What is the formula can conjuct all the txt into one cell?

Aussiebear
12-27-2016, 11:32 PM
Have a look at the concatenate function.