Forum Discussion
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.....
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 |