# Merging And Multiplying Cells Using Criteria

Oct 12, 2012

I want to merge some cells using a criteria. To be more specific, let's speak on the file attached.

Beginning with the P5 cell I want to merge to the right groups of 4 cells for each name from the column J. Therefore the first group of merged cells will be P5:S5, the next group will be T5:W5 and so on until reaches 11 groups of 4 cells. The last group will be BD5:BG5.

I tried a script like this but it says that there is a syntax error on the "Else" instruction:

Range(Range("AB5").End(xlToRight).Offset(0, 1), Range("AB5").End(xlToRight).Offset(0, nrCat)).Select

VB:
Dim i As Long
nrCat = Range("O2").Value
For i = 1 To nrCat
If Range("AB5") = "" Then

[Code] .....

## Multiplying And Subtracting Within Cells

Feb 5, 2014

I have a total number of hours I want to subtract from. Example in cell e3 I will have 800 hours. In cell f3 I have the number 2 (to represent 2 workers at 40 hours, so that should total 80). I then want f3 to multiply by 40, then that total subtract from the 800 hours in cell e3. Basically I want to be able to put 2 workers in a cell, have that multiply by 40 and minus from the 800 hours in cell e3. I want that to carry on for cell g3, etc.

## Multiplying All The Cells In A Column By 1

Dec 22, 2008

This is about my misformatted download again. It considers all the numbers to be text. Naturally, I need them to be numbers. I discovered a page on the Web that says if you multiply all the numbers by 1, suddenly Excel gets a clue and figures out they are numbers. I've tried this (as the page recommended) by using Paste Special, and it works. I know the command I need to use to get it to Paste Special:

## Multiplying And Adding Multiple Cells To Get A Sum

Feb 18, 2014

I have a spreadsheet with 4 columns.

A, B, C, D

I want to multiply A*B and then add that to C*D

=SUM(A*B)+(C*D)=TOTAL

However, when I dont have a value/number in A or C I get a #VALUE in the total cell. It will only calculate properly when I have numbers in all 4 cells.

Is there a way to set it up so it will calculate if cells A or C are empty? I dont want to have a zero in these cells - just leave empty if no value.

Also - when the total cell is empty I want it blank.

## Shortcut With Multiplying Hundreds Of Cells

Aug 17, 2009

I have over 500 countries with unique shipping costs associated with each... each of them has the same mark-up price... 2.25. I am hoping to be able to insert a formula that will cover each country... i am currently entering each one indivdually (E10*2.25), then the next one (E11*2.25), etc.

## 2003 - Merging Four Adjacent Cells With Text And/or Blank Cells

Jun 14, 2008

I am trying to merge text, in four adjacent cells in the same row (say cells A1,A2,A3 and A4), into a single cell (say cell A5).

I would like a comma or full stop and then a space between each item merged (cell A5).

The text to be merged may appear in any one of the four cells (cells A1 to A4). Those cells without text are blank.

Only where all 4 cells are blank, will I need cell 'A5' to indicate this.

The formula needs to be relative as I will need to copy the formula down the spreadsheet so that it applies to additional rows.

## Merging Cells ....

Jan 19, 2009

I have a column with data, the cells go data, blank cell, data, blank cell, data etc.

The row count will vary.

What I need to do is go through the non blank cells in the column and merge the them with the blank cells beneth them.

ie A2 = Apple
A3 = blank
A4 = Pear
A5 = blank

run the code to get

A2 and A3 = Apple
A4 and A5 = Pear

## Merging Cells ...?

May 25, 2007

I have data in two separate cells as follows:

Cell A1 = 7890
Cell A3 = 1

In Cell A4 I want to merge the figures as following figure:
789.01

What type of formula would I need to create for this to work for me?

## Merging Cells In Row That Have Same Values?

Nov 23, 2013

I'm trying to merge cells in a row (row 1, in the example below) that contain the same values. For example:

A A A B C C D D

into:

A B C D

I've used the following code, and it actually seems to work, but it gives me a runtime error and I can't figure out why.

VB:
Sub MergeCells()Dim r As Range, c As Range
Dim i As Long, j As Long
Set r = Range("A1", Cells("1", Columns.Count).End(xlToRight))

[Code]....

## Merging Data Of Two Cells Together..

Jan 14, 2009

I need assistance with a formula two merge data of two cells together. For instance I have a column 'first name' and 'last name' and I want to create a column of just 'name' and concatinate the data eg: John Smith. I have roughly 175 cells to do this for.

## Merging Cells Where Row Is Variable In VBA

May 27, 2012

Merging cells where the row is a variable. The code has two loops that consolidate date from two other sheets, it works fine but as you can see it puts the data into columns A,B and C,D respectively. My goal is to combine both into the A,B columns, which I can do very easily. My problem is that between the loops, marked by "HERE" i want to skip a line, merge cells A and B on whatever row that maybe and set an header.

Code:
Workbooks("Discovery Errors.xls").Sheets("Totals").Range("A3:U60000").EntireRow.Delete
Workbooks("Discovery Errors.xls").Sheets("Totals").Range("A3:U60000").EntireRow.Font.Bold = False

ActiveWorkbook.Sheets("Disc_Nodes").Activate
xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortTextAsNumbers
LastRow = Cells(Rows.Count, 1).End(xlUp).Row

[Code] ........

## Merging Several Cells Of Data Into One

Jun 19, 2014

How would I combine the data in 30 cells into one cell.

They all 12 digit numbers and I need them separated by a comma.

## Merging Duplicate Cells ..

Mar 25, 2008

how would i run a macro to merge duplicate cells in a column

For example, i have lots of data in columns A, B and C

however some of the data in columns A and B is the same. Column C data never changes. so to make it easier to read, i would like to merge these cells (which are the same) together?

-ColumnA-
Cat
Cat
Cat
Dog
Dog
Dog
Dog
Mouse
Mouse
Mouse
Mouse
Mouse

would become.... (with all the other data the same)

-ColumnA-
Cat

Dog

Mouse

I dont want to lose any of the rows, as the data in column C is always different. I just want to merge the similar ones, so its easier to read.

Its a bit like this, but i cant even come close to getting this to work:
[url]

## Merging Multiple Cells

Feb 8, 2007

Is it possible to write a macro whereby the data in numerous cells in a row, say A1:K1 are copied into one cell, L1 then the cells from the next row, A2:K2are copied into the same cell, L1 but on the line below in the cell. I know the above doesn't make much sense so i've attached an example.

## Merging 114,618 Cells Into 1 Very Long Cell?

Mar 30, 2013

I have a spreadsheet of barcodes 114,618 rows long. I have a program that requires me to enter in each and every barcode in a certain format. This is the format that it requires me to place the barcodes into.

23423432, 23432342, 234324323, 234322344, 432432432, .............

so and and so forth.

Only problem is my POS system exports the barcodes in a format that looks like this:

545554545435
345435435435
354543534534
354534545453

Now I have a Macro to add a comma to the end of these barcodes. That part was a breeze, however, I have hit a brick wall when it comes to placing them into an ongoing sentence type format, that my program needs. I have found several ways to combine and merge and "justify" the content, however these typically only cover small amounts of content, and doesn't even come close to hitting anything over 100,000. I don't know if maybe I need to be using another program in tandem with Excel.

## Merging The Contents Of Two Cells In One Third Cell?

Sep 11, 2013

How can I let cell F5 for example contain both the texts or contents of cells A1 and B1? Is there a function that can do that purpose?

## Merging Cells From Multiple Rows Into One Row

Jan 29, 2014

For my work I need to delete duplicate rows with the same name but keep the information in the (original) cell.

for example I have:

Cells: C D E F
Row 1 SoccerPremier League Holland
Row 2 SoccerPremier League Germany
Row 3 SoccerPremier League Poland Poland

I want to keep row 1 and add the data from row 2 & 3 with the data in the same cells so it will be:

Cells: C D E F
Row 1 SoccerPremier League HollandGermanyPolandPoland

As cells D, E, F are empty I would say you can just merge the 3 rows by selecting them and merge.

## Avoid Popup When Merging Cells

Sep 10, 2009

I am programming VBA for Excel and I have a problem with automatic popup messages. I would like to answer Excel's request "Selection contains more than one value. If cells are merged, only the first entry will remain" with OK. The cells are sorted, so they contain the same value, hence I want to merge them. Of course I could work around and delete every entry except for the first before merging, but I would like to know, how to answer this popup automatically, so that the user does not get to see it.

## Merging Multiple Cells Containing Text

Jan 26, 2010

I need to combine or merge text from cells in 20 rows of data into a format able to be printed. This is evaluation data for a class of 20 students, where each row is one students response to the evaluation, with the last cell in the row containing their comments (text data that may be blank, or up to several sentences in length). Here's what I'm trying to do:

Combine all 20 cells into one cell that can be printed (with word-wrap turned on).
Add a blank line between each comment.
Disregard any blank cells so extra blank lines are not added.

## Merging Cells With Similar Data

Mar 2, 2005

I am trying to merge two cells that have the exact same content in each cell. Everytime I do this, I get a pop-up warning that Im trying to merge cells with content in them and that only the upper-left content will remain. This is exactly what I want, without that pop-up, as I have to do this for multiple columns at a time.

## Merging Text Cells Formula?

Jul 19, 2013

is there a formula or macro for merging identical text cells in a column?

I am looking at data relating to familes with a row for each family meber therefore the address cells for each family are identical. I would like to merge these cells for ease of reference when printing the data to be used as handouts for staff attending the households.

## Merging Multiple Rows Into One Row With Certain Cells?

Oct 3, 2013

I am trying to do the following:

I have about 50,000 rows of user info, something like the below -

ID
First Name
Surname
Description

1
John
Smith
Associate

2
Rob
Page
Associate

## Merging Cells And While Retaining The Same Format

Jan 31, 2007

I have cells that contain number that have dashes

For example

Cell M contains the number 001-1234
Cell N contains the number 1234567 (I have formatted the cell to appear with a dash at the beginning -1234567
Cell O contains the number 891 (I have formatted the cell to appear with a dash at the beginning -891)

I want to combine the three cells and have the number look like this
001-1234-1234567-891

Is there a formula that will do this

I have tried the Concatenate to combine the cells but it just combines the numbers and won't let me format the number as I want it.

## Merging Cells With The Same Values AUTOMATICALLY?

Jul 7, 2008

How would I go about merging cells with the same values AUTOMATICALLY?

For instance in cells A1:E1, each cell contains a value of 4 except E1 so I require A1:D1 merged.

## Merging Multiple Data Cells Into One Cell?

Oct 24, 2013

I have a spreadsheet where I am trying to add up codes and quantitys, after this I want the repeated info deleted. For example;

12.004RWHB 4 Row Wooden Handle Welders Brush
12.004RWHB 4 Row Wooden Handle Welders Brush
20.004RWHB 4 Row Wooden Handle Welders Brush
24.004RWHB 4 Row Wooden Handle Welders Brush
4.004RWHBSS4 Row Wooden Handle Welders Brush S/S
10.004RWHBSS4 Row Wooden Handle Welders Brush S/S
12.004RWHBSS4 Row Wooden Handle Welders Brush S/S

So what I want to do is add the numbers up so I can get one value. For example, 4RWHB I want to add them all up so that it totals 68 still shows the code and description but then only shows 68 4RWHB 4 Row Wooden Handle Welders Brush and not the same line repeated. I want to condense all the information down so where there is same model numbers I can add it up and it doesn't give me multiples but summarises it down into one line per model number.

## Merging Table Cells With Text Under Certain Conditions

Aug 31, 2009

From a supplier I will get a spreadsheet including the the following Information which I need to convert into an url including trailing slash (/) for an online store.

Column A = Value of Main Cartegory (e.g. Holidays)
Column B = Value of Subcategory_1 (e.g. Christmas Decor)
Column C = Value of Subcategory_2 (e.g. Candle Holders)

Those raw data are without any trailing slashes.
Now I want to create a column e.g. Column D (product_url) which should be a summary of column A thru C but if there is only a Value for Main Category
there should be no trailing slash,
if there is a Value for Main Category and a Value for Subcategory_1: no trailing slash after Subcategory_1 but trailing slash between Main Category and Subcategory_1.

The result should look like this:
Holidays (Main category)
Holidays/Christmas Decor (Main category & Subcategory_1)
Holidays/Christmas Decor/Candleholders (Main category & Subcategory_1 & Subcategory_2)

Is it possible to create something like that in Excel at all since all values will only be text and the trailing slash is actually functional for Excel calculations but in this case it would have to be treated as "text".

## Finding Duplicate Data And Merging Cells

Nov 5, 2007

What I have is a massive table of data (15k+ entries), which consists of 4 different tables merged together. I have a lot of duplicate entries. However, most of these entries have information in one or another columns that its duplicate does not.

What I need to do is:

Identify the duplicate entries (by part number, which is one of the columns).

Merge the duplicate entries. In the merging process, I need to carry information over, taking data that is currently in 2 or more rows and merging it into one row.

Here's an example:

column1 column2 column3 column4
row1 a . . d
row2 . b
row3 . . c

needs to turn into:

column1 column2 column3 column4
row1 a b c d

If I'm not explaining this well, I will do my best to clarify. My main question is, is there any way to automate this process (even partially)

## Merging Values From 2 Cells To Get Month And Year

Feb 26, 2012

I have 1 cell where i am entering month like 2 (for FEB) and in other cell i am putting value 2012 (year)

I have 1 more cell where i have to manually add 1st date of the month like: 01-02-2012

Can I merge first two values and let excel automatically return 01-02-2012 in my desired cell.

Also if i need to convert 02 to FEB or 03 to MAR then what is the formula for this.

## Merging Cells Based Upon Condition In Different Cell

Feb 26, 2013

I am trying to automatically merge cells based upon a condition in different cell. Below is the example of what I would like to achieve.

Apple
Red

Apple
Red

Apple
Red

[Code] ......

## Multiple Formula In One Cell / Merging Cells?

Nov 7, 2013

I want to create a string of 0's and 1's in the same cell in excel.

I used the function =randbetween(0,1) to generate 1's and 0's. Just wondered if there is a way to repeat this multiple times in same cell so it looks like 1 0 1 0 0 1 etc... as an example. Or a way to merge cells?