merging cells

  1. A

    Merging four columns with some highlighted cells into one column showing only those highlighted cells

    I am sure there must be a simple way to do this but I cannot find the solution by searching the web. I am looking at patients with burns. Each row represents a unique patient. The diagnostic code for the size of burn occurs on one of four columns in the worksheet. I have used conditional...
  2. A

    Merging multiple cells with content

    I haven't been here for a long time but you guys have helped me in the past immensely when I was building an excel based text analysis tool (see https://www.academia.edu/30391368/PDD_Poetic_Devices_Detector_) I am now busy with something else text based and need more help. Given a table with...
  3. J

    VBA join row of cells if value found

    I am trying to join cells in a row if a value exists in a cell in that row. The data has been imported from a .txt file and various sub headers are split along 2, 3 or 4 columns. The cells cant be merged as the data will only be kept from the first cell. The only words which are always...
  4. R

    A mix of Merged/Split Cells in a row to reflect a "family" of separate actions relatint to a "parent" cell?

    Hi all - I'm hoping this is something that can be fixedin Excel to be achieved in one single sheet. I'm building a worksheet to hold client account plan summaries with multipleentries of a client, by my involved offices/teams, with text summaries but cruciallyincorporating a list of actions...
  5. T

    Using a Variable references to indicate a range of cells to merge

    Hey Everyone, I was wondering if it were possible to use variables to reference cell values in a range to merge? I am using Excel 2013. Here is my current code: Sub CompanyHeader() Dim StartRange as String Dim EndRange as String StartRange = "A1" EndRange = "J3"...
  6. B

    Macro that can merge cells

    Hi All, So I have a data set similar to this: ColA ColB ColC ColD <colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody> AAA QQ T 64 AAA QQ T 91 AAA QQ Y 55 AAA WW T 8 AAA WW...
  7. E

    merging duplicate donors and donation amounts from different years

    hi i see lots of posts about merging but could find none that really address my problem. im trying to organize a 10k+ name donor data base list that has names of donors, with how much they have donated, every year in yearly increments starting from 2006..... the problem is that excel displays...
  8. K

    Merging cells

    I am looking to merge a column of 630 cells into one cell with the values separated by "_," For example 12 13 14 15 16 would merge to: 12_,13_,14_,15_,16_, Any thoughts on this? Im struggling to automate the macro such that is works for varying amounts of cells (500 in one sheet, 30...

Watch MrExcel Video

This Week's Hot Topics

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
Top