Google Sheets or Microsoft Excel - Merge cells but only horizontally

[creat0r]

I have a sheet with over 2000 rows. The contents of column B and C should both be in column B, so we need to merge the C with B. So I only want to merge cells horizontally. How do I do this in Microsoft Excel or Google Sheets?

 

[Avocado Diaboli]

If it only needs to be in column B, why do you need to merge it? Without knowing the details, I'd just suggest using another column to concatenate the values with the appropriate spacing and overwrite the contents of the original cells or just delete the original columns.

 

Basically do this:

 

Now apply the formula to the entire column.

 

Before deleting the original data, select column C, copy the contents with Ctrl-C and without moving the selection, right click and paste the copied data as values (the symbol with "123"). That overwrites the formula and writes the values into the cells as text directly.

 

Now you can delete column A and B.

[Dedayog]

27 minutes ago, creat0r said:

I have a sheet with over 2000 rows. The contents of column B and C should both be in column B, so we need to merge the C with B. So I only want to merge cells horizontally. How do I do this in Microsoft Excel or Google Sheets?

 

When you say merge, you want to do it like @Avocado Diaboli shows?  Maybe add a dash in between?

 

Are you wanting to show a range of values?

 

Seems an odd way to show data, IMO.

[creat0r]

2 hours ago, Avocado Diaboli said:

If it only needs to be in column B, why do you need to merge it? Without knowing the details, I'd just suggest using another column to concatenate the values with the appropriate spacing and overwrite the contents of the original cells or just delete the original columns.

 

Basically do this:

 

Now apply the formula to the entire column.

 

Before deleting the original data, select column C, copy the contents with Ctrl-C and without moving the selection, right click and paste the copied data as values (the symbol with "123"). That overwrites the formula and writes the values into the cells as text directly.

 

Now you can delete column A and B.

Thank you! I just needed to create a new column and write =B1 & ", " & C1 and then drag down to show both values in a cell with a comma and space between. Thank you!