Forum Discussion
merge to values in one cell
hi team, I want to ask that I have data in excel in different cell, and I want to merge two values in one cell. from example; value Should be like this 12000 12001 1 13000 1300...
Here is another alternative, using OFFSET()
=IF(ISEVEN(ROW()),CONCAT(A2,OFFSET(A2,1,0)),"")You have now several options
Let us know what works best for you
David