merge cell and move next one to the right

Hello,

Why would you want to merge a cell? And merge with what? If you want the contents of cell A1 and cell B1 in one cell, then insert a new column after column B. Then enter this formula into cell C1 (the first cell in the new, empty column):

=A1&B1

Copy down as far as required.

If that does not help, please provide more information about you scenario. Upload a sample file and mock up the expected result.

cheers, teylyn

For what it's worth: the Concatenate function is pretty much useless. It just adds typing overhead to a formula.

Compare

=A1&B1&C1&D1

with

=Concatenate(A1,B1,C1,D1)


The ampersand (&) operator is always shorter.