Merging Columns

Copper Contributor

Is it possible to merge data from adjacent columns?

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

@Todd_1961 

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.