Merging Columns

Occasional Visitor

Is it possible to merge data from adjacent columns?

2 Replies
= CONCATENATE (B2, “”, C2)


If you mean to merge two cells keeping in resulting merged cell concatenated values from source cells - nope, that doesn't work such way. You may put such result into the third cell using suggested or like formula.