Excel Macro merge cell contents and separate by soft return

**WesternGal** · 05-17-2013, 10:39 PM

Please Login or Register  to view this content.

Test.xls

Please Login or Register  to view this content.

I am trying to put together a macro that will:
1. Merge the contents from two cells together (i.e., C3:C4 merged into C3)
2. Separate the contents with a soft return in the merged cell

The contents or values do not need to be added, as in 1+1 = 2. The values need to remain separate.
I found a method to merge the two cells, but it deletes the contents from the second cell.

Is there a way to merge the two cells, or copy the contents from C4 into C3 and keep the contents separated by a soft return?

Thanks!

Please Login or Register  to view this content.

**HaHoBe** · 05-18-2013, 01:26 AM

Hi, WesternGal,

merging cells means putting the cells together into one cell - you will have only one cell physically which stretches across two cells.

Maybe this code will lead you into the direction where you want to go. As it is working with ActiveCell please choose cell C3 before you run the code:

Please Login or Register  to view this content.

Ciao,
Holger

**WesternGal** · 05-19-2013, 09:32 PM

Holger,

Thanks for the reply. I'm not really sure where to go with this code; it gives me a message box, but doesn't merge the contents.

I recorded a macro to see if I could build off what I needed.

Please Login or Register  to view this content.

However, I wanted something that would copy/paste the cell contents, not a specified number since each table will have different values. I came up with this, but it does not keep the formatting, although it did in the above macro. (i.e., a 14% becomes .14)

Please Login or Register  to view this content.

Is there any way to keep the formatting? Or should I repost as a separate question?

Thanks,
Western Gal

**HaHoBe** · 05-20-2013, 01:46 AM

Hi, WesternGal,

still don´t get for which range this action should be taken. The difference bvetween your recorded macro and the sniplet is that you take the value and my code relates on what is shown in the cell.

To paste the contents into the active cell use

Please Login or Register  to view this content.

The code will place the contents to the left of the cell (as this is a string that´s put in) and it doesn´t change the formatting when I use it with Excel2013.

Ciao,
Holger

**WesternGal** · 05-20-2013, 06:51 AM

Holger,

The code worked! Thanks for your help.

WesternGal

**WesternGal** · 05-20-2013, 10:05 PM

One final note for those newbies like myself . . . I didn't want to have to select a cell each time I need to merge cells since I have several tables, I added a line to select the cell, then combine the contents. Of course, this only works since the info is always in the set cells.

Please Login or Register  to view this content.

**HaHoBe** · 05-20-2013, 10:26 PM

Hi, WesternGal,

maybe use these instead of changing the range for each individual cell, first uses a given range, second needs you to choose the range on which it should work prior to running the macro:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

**WesternGal** · 05-28-2013, 08:14 AM

Thanks -- worked beautifully!

Excel Macro merge cell contents and separate by soft return

LinkBack

Thread Tools

Rate This Thread

Display

Excel Macro merge cell contents and separate by soft return

Re: Excel Macro merge cell contents and separate by soft return

Re: Excel Macro merge cell contents and separate by soft return

Re: Excel Macro merge cell contents and separate by soft return

Re: Excel Macro merge cell contents and separate by soft return

Re: Excel Macro merge cell contents and separate by soft return

Re: Excel Macro merge cell contents and separate by soft return

Re: Excel Macro merge cell contents and separate by soft return

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions