join cells in column

  1. P

    Concatenate with if conditions

    Hi everybody. I need some help in getting the code to do the follow: 1 CONDITION : if CODE A is repeated 2 CONDITION : if STATUS E is ok then : concatenate invoices & REF but : skipp all double REF. IF THE STRING IS SHOWN ON EACH LAST CODE ONLY...
  2. G

    VBA Concatenate Range To Single Cell for Multiple Columns And Loop Over Multiple Sheets

    I'm trying to combine the contents of the 2nd through 5th cells in each column where any of the first 5 cells has something in them. Ideally this could be applied to a list of worksheets (say SheetA, SheetB, SheetC). The worksheets are updated every 30mins from a web based table so I need to...
  3. R

    Retrieve and combine/join cell data with specific criteria

    I am currently using this formula to retrieve and combine multiple cell data into one cell and make them comma separated JOIN(",",TRANSPOSE(B3:B69)) But is it possible to do the same but only retrieve cell data in column B is the corresponding A column cell equals certain criteria (example =...
  4. O

    joining content of cell based on condition

    Hi, I need to join the contents of the cell in column c with the cell above it if column h is blank. There will only be two blanks in a row under column c at any one time, once there is a third blank then the data is finished. Can any one help. Regards ocramza
  5. S

    Need VBA to combine cells in a column

    I have data in multiple cells in column E. I need to join them all together in cell K1. Please help.

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