concatanate

  1. J

    Combining cells with the same data but keeping some data separate

    Good afternoon all. Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in. As you can see below - A, B and C all share the same data and i need them merged into...
  2. S

    VBA dynamic concatenate

    Hi, First of all, my level of VBA knowledge is hacking together things I find on the internet, so I apolgise if this is a stupid question. I have the following table (made up details, but same format): Server Patch No Date Server 1 1 27/04/22 Server 1 2 27/04/22 Server 1 3 27/04/22...
  3. R

    Copy data from closed workbooks in multiple folders into one master sheet

    Hi all, I'm quite new no VBA, so trying to find my way here. What I am trying to do is to copy a row of data from seperate Excel workbooks, located in different folders into one master sheet. So what this looks like is that I have the following files in these locations...
  4. J

    Excel 2016 How to conditional concatenate

    Hello, I'm working in Excel 2016, unfortunately this can't be updated due to work. In column A I'm trying to get the cells to read off the question numbers of the first 6 incorrect questions and column B the corresponding MW clips that go with each of those first 6 incorrect questions. Any...
  5. A

    VBA - Concatenated data in one cell; delete entire row when 1 piece of info is not present

    I run a report that displays a list of employees with all the information associated with their employment record. One of the things on there is a concatenated list of all their Employee Roles, with a Valid To and From date. For example, if the list of possible Roles is as follows: Role 1 Role...
  6. M

    Concaténer des cellules avec une condition

    Good morning all, I wanted to concatenate colors (in range B) with respect to each value which is in row A. (see image) . The result is in Range C. I used concatenation with condition like this: = IF (A2 <> 0; CONCATENATE (B2; ","; B3; ","; B4; ","; B5; ","; B6); "" ) because sometimes there...
  7. K

    Concatenate with rows and primary key type scenario?

    I have a range of participants who all have unique identification numbers and they have taken multiple speaking series classes. These classes are listed on an excel worksheet with different rows. I want to concatenate them all together using the primary key as the unique identifier so that they...
  8. Y

    Merge data from multiple cell with the conditiion that only if the cell has data in it as well as add HTML list element

    <tbody> </tbody> This is working fine. =CONCATENATE( IF(E5<>"", ""&$E$3&CHAR(160)&$E$4&CHAR(160)&E5&" ",""), IF(F5<>"",""&$F$3&CHAR(160)&$F$4&CHAR(160)&F5&"...
  9. Q

    Formula to Concatenate Unique Values into 1 cell

    Hi there, I have some major limitations of not being able to run macros from Excel and was wondering if it was possible to use a formula for the below instead? From: https://www.extendoffice.com/documents/excel/3418-excel-concatenate-unique-values.html <code class="vb keyword"...
  10. V

    Multiple condition Situation

    Hi all. This is a rather complex situation hopefully someone will be able to help. I have 3 drop down menus as below. Cell A1 -Cell with numbers in 50cm increments from 100 to 1000 Cell B1 - Cell with drop down menu which includes 3 types of rails. Cell C1 - Cell with drop down menu which...
  11. K

    Force formula built via concatenation to calculate

    Just like the title says. I have a COUNTIFS formula I built in pieces and glued together using cell concatenation. The formula works just fine, but I need to click into each individual cell, and hit enter, for it to calculate. I have 16K cells. How do I force XL to look at it as a formula and...
  12. M

    2 sperate Font sizes in the same cell

    Hi Im using excel 2010 can anyone help me in in creating 2 sepertate size fonts in the same cell the first font is size 128 Arial & the second font size is 20 Arial the formulas are in coulmn "E" & "F" (Vlookups from another sheet), i concatanate them with a space inbetween and word wrap so...
  13. J

    How to ignore cells while concatenating cells in Excel

    Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N". For example, below I would like to skip 4and 5 because column A has "N". ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left...
  14. P

    Modifying UDF for ConcatenateIF to ConcatenateIFS

    Good morning, I found a great UDF that concatenates a range of data based on another range meeting 1 criteria. It works perfect, but I want to add another condition to the criteria but I cant get the wording correct. Here is the UDF for the 1 condition: Function...

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