tags:

views:

43

answers:

0

My secretary made a stupid database in excel using different rows numbers in excel. The first entry uses A2, B2, C2,C3,C4, D2. The second Entry uses rows A5,B5,C5,C6,D5, and so one, so that i don't have a constant number of rown. I will probably start inserting rows so that the number of rows is equal for every database insertion. I have to combine the information of those cells and i don't know how i have tried a formula something like =A2&" "&B2&" "&C2&" "&C3&" "&C4&" "&D2, it is a succes only for printing. it is actualy a shortcut to gather it's only a visual label. I have to copy the information from those different cells to create one cell with all that info