Using fx CONCATENA in EXCEL 2010 for dats in cells on the same raw

[fabiomig93]

Hi, i'm trying to use concatena for about 300 cell on the same raw.
FE datas are in cells D2:JY2 and I need to unite all this datas, how can i do?

the only way is to write: =concatena(d2;e2;f2....jy2)? there is no way to select all the cells at once?

Thank you in advance 

[#2]

@fabiomig93 Hi,

You can do this easily step by step by concatenating 2 cells first and then concatenating third cell with output of first concatenation, and then concatenating the fourth cell with output of previous concatenation, you don't have to type formula for each concatenation, just need to copy / drag the formula, then the resilt of the final concatenated cell is what you want..

See below and attached file for example :-

Memo:	Formula zero	Formula one	Formula one copied	Formula one copied	Formula one copied	Formula one copied	Formula one copied	Formula one copied	Formula one copied
Formula :	=CONCATENATE(D4)	=CONCATENATE(D3,E4)	=CONCATENATE(C3,D4)	=CONCATENATE(D3,E4)	… so on…
Result :	jan	janfeb	janfebmar	janfebmarapr	janfebmaraprmay	janfebmaraprmayjun	janfebmaraprmayjunjul	janfebmaraprmayjunjulaug	janfebmaraprmayjunjulaugsep
Data:	jan	feb	mar	apr	may	jun	jul	aug	sep