merge blank cells

  1. K

    Question: Merging two columns; only overwriting blank cells

    Hi, I was search online and found old thread Merging two columns; only overwriting blank cells with the solution below which works great but only if I type in the =K7 formula in each cell. I will have 1000's of blank cell after I do a Xlookup. Is there anyway to get the formula to auto fill all...
    • Kimb
    • Thread
    • columns merge blank cells merge columns
    • Replies: 1
    • Forum: Excel Questions
  2. N

    concatenate or merge cells for every change in a non-blank cell

    Hi - first time poster here! any help greatly appreciated! I am trying to use excel as a quick way to format a transcript and either concatenate or merge cells to aggregate comments by a speaker, please see below example of data and my first ideas at the logic of trying to resolve: Column A...
    • natforde
    • Thread
    • concatenate concatentate by a value merge blank cells
    • Replies: 10
    • Forum: Excel Questions
  3. D

    vba to merge cells

    Hey guys, im looking for a vba to merge the current cell with all the blank cells below it. I'm automating a report, which turns into a pivot table, and then i need that pivot table in text format for something else. I was thinking of doing something like this and merge cells while recording...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top