Forum Discussion

fabiomig93's avatar
fabiomig93
Copper Contributor
May 08, 2020

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

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 

excel

1 Reply

  • amit_bhola's avatar
    amit_bhola
    Iron Contributor
    May 08, 2020

    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 zeroFormula oneFormula one copiedFormula one copiedFormula one copiedFormula one copiedFormula one copiedFormula one copiedFormula one copied
    Formula :=CONCATENATE(D4)=CONCATENATE(D3,E4)=CONCATENATE(C3,D4)=CONCATENATE(D3,E4)… so on…    
    Result :janjanfebjanfebmarjanfebmaraprjanfebmaraprmayjanfebmaraprmayjunjanfebmaraprmayjunjuljanfebmaraprmayjunjulaugjanfebmaraprmayjunjulaugsep
    Data:janfebmaraprmayjunjulaugsep

Resources