concatenate

  1. Kobi Merrikin

    Combining multiple cells into one

    Hello! This is my first post on Mr Excel :) I am trying to collate a list of numbers so they have an exclamation mark at the start and a semi-colon at the end. I wish for these to all end up in one cell so I can copy and paste them into a business intelligence system that requires this format...
  2. S

    Sum from sheets name based on another cell valu

    Hi I have Key & sheet names in Sheet1 & key(with Concatenate) need to vlookup with Key in another sheets & get the Sheet Name & sum the column values.
  3. A

    VBA: concatenate data

    I have data in Column A1:A100 and B1:B100. I need to Concatenate data in C column so that column A data appears below column B data in respective cell.
  4. L

    Formula to Find matching Absolute Values in a Range of Dates?

    Hi Everyone, I've been developing a project for work that will analyse bank accounts to determine the value of a project. The problem is some of our projects have inter-account transactions. In order to determine the proper worth of the project we have to find any transfers between the...
  5. K

    Extract list of non-zero cell values from a list AND whether Estimate or Actual AND the name of the product

    I have a list that I need to remove the zero value items from via formula to create a new list (imagine an order form). Because people will be using this second form without much excel knowledge, I need it 100% formula driven. <colgroup><col><col><col></colgroup><tbody> Qty Item Estimate...
  6. X

    Contatenate with blanks

    Hi MrExcel World, I am trying to concatenate 2 cells, which is easy enough. The problem I am having is that one if one of the cells is blank I don't want to return anything. Example below; Concatenate----------------------First Name----Last Name John...
  7. T

    VBA to Concatenate across multiple workbooks

    I'm trying to write a VBA that will concatenate the same cell across a whole folder of workbooks. Each workbook in the file is the same, just a different topic. I have 15 different workbooks, for example I have Lion, Tiger, and Panther. In sheet 3 column D of each of these books I have some...
  8. N

    TEXTJOIN unique names (columns) - ignore blanks

    I am trying to concatenate unique column text into a single cell. After spending an afternoon researching, I can now concatenate all the text in different column cells and remove duplicates. However, if one of these cells is empty, I get a blank value. as an example, I want to concatenate all...
  9. willow1985

    Concatenate formula for dates

    I have 2 columns (K and L) with the dates in the format: 08/27/2019 & 08/29/2019. I want to use a Concatenate formula to have the end result showing: Aug 27 - Aug 29. The formula I wrote is as follows: =CONCATENATE(TEXT(K3,"[$-409]mmm d;@")," - ",(TEXT(L3,"[$-409]mmm d;@"))) However this...
  10. D

    Concatenate different columns with delimiter

    Hi there, I am trying to concatenate different columns from 2 sheets, which are in different order one to each other. This would be the columns i need from the Auto sheet, and their counter from Manual sheet: <tbody> Auto Manual Column Column Q AB S T T U U AN V V W AQ X AT...
  11. P

    Concatenate & Remove Duplicate

    I have the following column values Input Account no Code 000005678 ABC 000005678 EDF 000001234 ABC 000001234 ABC Desired Output Account no Code 000005678 ABC 000005678 EDF 000001234 ABC Criteria Concatenate Column A and B (i.e...
  12. Dazzawm

    Easiest Way To Concatenate

    I have a sheet as below with several dozen columns and thousands of rows. I want to join each column separtated by a / and a space. They are set out like below but if i do a normal concatenate formula I could end up with row 2 something like 8E0145806Q/ / / / / /. Row 4 is what how I would like...
  13. R

    Query changing dates to numbers and pulling data incorrectly

    Currently I am trying to figure out why Query is changing the information and pulling on cells it shouldn't be? I have a table setup which is this: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 100px"><col...
  14. S

    Concatenate with different date formats

    I use concatenate to create a code so I can use vlookup. The source of data comes from 2 separate sheets. The issue is I get two different result using concatenate (i.e. formula = concatenate (A1,B1) which is the date,client's surname. The two different results from the two sheets are...
  15. S

    Concatenate $ amounts

    I want to concatenate 2 $ amounts but I lose the $ and the , in between the numbers. For example: A1 = $100,000 B1 = $200,000 C1 = concatenate (a1," & ",B1) The result I get is 100000 & 200000 So I lose the $ and the commas. Any suggestions? thanks
  16. H

    HELP Excel Formula: concatenate if cells (col) is not blank

    concatenate if cells (col) is not blank anyone can help me :) <tbody> H K L (Result) ABC no result due to K is blank. Formula here ABC D ABCD </tbody>
  17. gheyman

    Concatenate formula

    I have a list of items down column B. The number of items in column B will vary from time to time. I am trying to concatenate each row in B (concatenate(B17","B18,".... I need them concatenated No spaces and separated by a "," My problem is how do I only concatenate down the list to where...
  18. B

    Using an IF statement to combine text with a variable.

    Failing at every turn to get the correct formula. IF cell P1 contains the word Delivery concatenate 3 cells together. This I have been able to do. but adding If Cell P1 is equal to Pickup then merge these 3 cells. When it says Delivery im good but otherwise I will get a False return instead...
  19. M

    Help with Concatenate to exclude cells with no data

    Hello, I have a spreadsheet that is concatenating multiple ranges of data to formula a note that can be copied and pasted elsewhere. Unfortunately I can't figure out how to exclude blank cells and instead I'm getting 0's in my final note, like this: <tbody> #D9D9D9[/URL] , colspan: 2"]...
  20. X

    How To Concatenate Conditionally?

    Dear All, I do have the sample data set across A1:C6. I would like to concatenate as follows:- <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Region Store Result East a East b East c a-b-c West d West e d-e...

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