formula = concatenate

  1. N

    Concatenate two columns keeping date and time formatting

    Hi guys! I have a column A that refers to dates in the custom format: "mm/dd/yyyy" and a column B that refers to times in the custom format: "hh:mm:ss". Well, I need to concatenate both columns and create a column C but keep the format of the previous ones. Example: Column A: 01/25/2022 Column...
  2. G

    if the cell contains multiple text criteria then return the corresponding text criteria

    Hi Please can someone help, I have a formula that looks at a cell and returns a 1 if it matches the criteria and doesn't contain another specific word. Here is the formula: =AND(COUNT(SEARCH({"Apple","Orange","Peach"},$A2))>0,COUNT(SEARCH({"Pears"},$A2))=0) The problem I have is I want it to...
  3. J

    Macro wont run formula

    Hello, Here is my code: Sub Wordpress_CSV_Insert_Formula() Dim lastRow As Long lastRow = Range("A" & Rows.Count).End(xlUp).Row Range("C2").Formula = "=CONCAT(B2, " (", A2, ")" )" Range("C2").AutoFill Destination:=Range("C2:C" & lastRow) End Sub I get an error on...
  4. Jyggalag

    Please help me wrap up my IndexMatch formula (90% done)

    Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...
  5. S

    VBA Datum to new sheet Format CopyPaste special Formula CONCATENATE

    Sheet1 Datum I am very happy because I am Years years old 31.3.2021 20 =CONCATENATE(A2;B1;C2;D1) 44286 I am very happy because I am 20 years old The result in the Sheet2 workbook that I need to achieve 2021-03-31 I am very happy because I am 20 years old Result copy...

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