concatenate

I created this formula to filter =CONCAT(IF($A:$A=$C2,$B:$B,"")) and if working perfectly. However i'm having issues with creating a VBA for it. Basically i want to combine the text in column D based on the reference code in Column C. Been working on this for hours! any help would be much...

Hi there! I am trying to write VBA code to execute the following (visual screenshot attached) If the concatenated store and zip code value (ex: Walmart98101) is repeated in any of the columns (ex: columns C, E and F), I need to ensure the value of row 1 is the same in each instance of the...

Hello, I need loop that would create concatenate from fixed values (strings) and loop it based on input range (dynamic, user input). For example, "create image", input range 001-245, ".jpg", "image created", input range [same as 1st one]. Result would give create image 001.jpg image created...

Hi can anyone help please, I am trying to create a formula that looks down a list of data and concatenates the names of two if conditions are met? So in the example of shop is A and region is North then concatenate names save and Mike. Thanks!

hello! would like to ask how to go about concatenating Range("A1:D3") into one cell as seen on "G1" Thankyou!

I have data in Sheet1 in Column A & B. In Column A I have Data, based on the Column A Data there are data in Column B, I want that in Column C those data of Column B should place in a cell by sepearated by a Comma...

I am trying to output concatenated content into defined columns. There are 6 pre-defined columns (see the image below): Requirement Text, Requirement Rationale, Requirement Guidance, Requirement Lessons Learned, Verification Rationale, Verification Guidance, and Verification Lessons Learned...

Hi all, I'm struggling to make up some formula where I can populate a cell with multiple results based on a specific value. Idea is that I have 1 big table, where I would lookup a value, and that value would show from 1 to X rows, and from that filter lets say, there are 2 columns id like to...

Hello forum, I have a workbook, that I use to import data into our ERP. I have 3 columns(E,F,G) that I will input a number into. I want to concatenate the 3 columns in Column H. While inputting nothing if the column is empty. EFGH1Depot 1Depot 2Depot...

Hi, I am trying to combine shipping address information but some cells are blank e.g. some addresses have a company name, some don't which leaves an empty line. I am using the below formula. =A2 &CHAR(10)& B2 &CHAR(10)& C2 &CHAR(10)& D2 &CHAR(10)& E2 &CHAR(10)& F2 How can I make it so if a...

He All, I've got the below VBA which concatenates cells B&C into D, but also clears cell D if B&C are manually cleared. It works but it is very slow. If I remove the if statement for clearing the cells the concatenate works perfectly fast by itself. I'm wondering on how to improve this so that...

I am building a tool that the user can use to create a UTM based on criteria they have selected. I have created a list validation for 2 fields that depending on which the previous selection. The selection is dynamic so what ever is chosen as a "Channel" then the "Description" list will only...

Hi everyone! I have a single cell with contains a concatenated bunch of values. It looks like this Orange-Blue-Green-Pink-Yellow-Green3-Cyan-Majenta-Brown-White-Aqua-Black The concatenate is variable and changes a lot in size so it cant really be hardcoded Im trying to make it trim these words...

Hello, this is what I need to complete for a soonTM project that I will be involved. Explanation: I have 2 sheets: Matrix and Info. First, I need to check what number of Matrix I am going to use. For this, I go to sheet "Info" and for this example I will need to use the Matrix 40 (Note that it...

Hi - first time poster here! any help greatly appreciated! I am trying to use excel as a quick way to format a transcript and either concatenate or merge cells to aggregate comments by a speaker, please see below example of data and my first ideas at the logic of trying to resolve: Column A...

I have a workbook where I have 3 tables stacked on Sheet1. So for example: The first table starts from A2 and ends on A10, the second from A13 to A19 etc. I want to extract the first column values purely on unique values and without the headers or blank cells. So it should give me a nice...

Below is a screenshot of a workbook with a sample of what I am trying to do. I have a sheet with a tab labeled "MATERIALS". The sheet contains a list of materials in column A and in column B is the corresponding value of the materials On a second sheet with the tab labeled "PROJECTS" I have a...

Hi all, I have a large sheet already with many orders, and many variations on planet types inside as a table to look up. If I were to add the planet type next to the original data, it would have to match the "ORDER CODE". Here is an example of the lookup table on Sheet 2 to get the resulting...

Hi there, This is my first post since I am lost. Thanks for setting up this site! I received this huge sheet with a list of projects in column A. Each Project uses Deliverables (Columns B to Z+). The goals are: - Find total $-amount spent on deliverables for each KEYWORD found in row 2. -...

I have been trying to concatenate cells from a different master sheet into one cell for a label. the problem is that some parts of the text are bold (for allergens) and when I finish it erases all the formatting from original cell. I've tried several different macros and nothing works. Please...