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

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

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

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

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

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

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

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