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...

Some videos you may like

This Week's Hot Topics

Top