concatenate

Good day mate, need some guidance here 1. got a code with some loop error and 2. would like to parse the cell value into adjacent column attached here is the source, Code Result and Expected Result (Hopefully) source Michael Smith (49/Male/Hospitalized/Alien/DRIVER)James Smith...

This is a simplified version of what I need to do; to summarize the situation: - I have a table with many columns (only 3 are relevant for now) - Some of the rows may contain identical data in these columns (ex. the duplicate Shirt-Red-A) - I need a single cell to contain the "Brands" that have...

Dear MrExcelites, Need your help in modifying below macro to count hyphenated range as below. Sub ConcatenateRefDesignator() Dim a, w Dim i& a = Cells(2, 1).CurrentRegion With CreateObject("scripting.dictionary") For i = 2 To UBound(a) If Not...

Hi, I've created a formula that works fine if it is within the sheet where the data originates, if is filtering the routes our vans will be taking and excludes any blank routes (if a van is not scheduled out that day). But I want to have the summary in another sheet dynamically changing based on...

I'm trying to create a RAG status for dozens of metrics. Ideally I would like an IF statement that takes account of signage in B and D in combination with values in C and E to assess the value in G to output in H. However it seems you cannot concatenate the signage and values as it thinks the...

Hi, I am able to assemble a cell range (O21:O162) using this formula: =CONCATENATE("O21:O",ROW(XLOOKUP(INDEX(B21:B670,MATCH(TRUE,B21:B670<0,0)),B21:B670,A21:A670))) But when I insert it into a sum function, I get a #VALUE! error. Can someone show me what I'm doing wrong...

I'm not understanding why the code below will generate a #REF! error on the last cell identified to be concatenated (Row 3: Minnie Mouse), yet when I go into where the formula is copied, and I physically replace it with the cell I reference, it gets me exactly what I want (Row 2: Mickey Mouse)...

Hi Excelites, Need macro help to concatenate for below table. Rows value in single cell based on value in column A. example as demonstrated below table. ABCDE1Item CodeVendor NamePo NumberQuantityDate2EH1D006-00012KINTECH ENTERPRISE45000954984449593EH1D006-00012KINTECH...

I am still a newbie to most Excel functions. I have created a workbook with IF Statements, VLOOKUPs, Concatenates, and VBA Codes. However, due to an annual rate increase, I need to create a complex IF Statement for just this month and I can't quite wrap my head around how to do it. Currently...

Hello everyone, I need to refer a worksheet to modify some properties. My problem is that the name comes from a index value. The sheet name is Template1(1) and is the sixth sheet. Worksheets(cell + 5).Visible = True --> works fine and do the job, but how can I call by his name? If there...

Good afternoon all, I have tricky request here and hoping someone can help with it. As you can see the first column depicts the Individual in charge of each account - John DOE. Then the account number, account name, unit type and finally product code. I need a formula that can combine all...

I have a formula that is not working, however, I cannot figure out why. All works perfectly until I add the ")" at the end. I need it to reflect the close bracket at the end. Can you please show me what I'm doing wrong with this formula? =CONCATENATE("Current ",CHAR(10),"(",(TEXT($G$1,"Mmm...

I have a spreadsheet with POS SKU numbers and I want to create two rows below each SKU with the same SKU number with one adding cc to the end of the SKU and inserting it before the original SKU, and then below that another original SKU with the same original SkU with c concatenated for 1,000's a...

Dear All, Need help to create a macro which will give me the output as given in Column I (Output). Column C, D, E, F needs to be concatenated and then the macro needs to provide data for each "Supervisor Email" together in a single cell in Column I. The number of rows in the data keep changing...

Hello, I'm having difficulty trying to limit the decimal places to 2... the photo attached will show my code and my issue in cell G3; the reading for the dollars is more than 2 spaces. Is there a better code I should be using for this type of output?

hi all, hope someone can help , i beleive it should be simple but cant get formula right .. i need to concatenate all row cells on left if right cells is empty and continue for rest of sheet pls find the sample what is needed . thanks description credit debit expected result credit debit...

Hi Guys, I'm trying to do a concatenate on some data that would base on how many data present on column A (header not included) and column B1-F1 (header not included), I tried recording a macro but unfortunately even though column A is only counts until A16(not fix number and may changes...

Hello everyone, I'm VERY new to VBA and am trying to achieve the following outcome: I would like a range of cells (e.g. E1:E5) to be concatenated with CP-0001;, CP-0002; and CP-0003;. So, if the contents of cell E1 is 12345 I would like the output to be CP-0001;12345, CP-0002;12345 and...

Trying to find a sensible improvement to below formula, such that separators " | " would only be included for the cells that are in fact populated. To avoid outcomes like this: ABC EFG - KF12345|KF54321|||||||||||||||\ But instead to get automatically result like this: ABC EFG -...

Hi all, I have the below data, in column L: COLUMN L 1 2 3 AADDYE 4 FJGLLT 5 FJJDUE 6 FJGOTR 7 ADREWS 8 FSERTT 9 MBJGFR 10 FKOORR I want the output as per below when I run the marco to be: "AADDYE","FLGLLT","FJJDUE", - looping until the final data...