Forum Discussion
M.Yasir Fakhr
Aug 03, 2019Copper Contributor
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...
Twifoo
Aug 03, 2019Silver Contributor
As an alternative, you may use Ampersand (&), like this in B2:
=IF(ISEVEN(ROW()),
A2&A3,
"")