concatenate macro

  1. S

    Concatenate data from mutiple cells only if they contain certain values

    Hi Gurus, I'm new to this community/forum and I am hoping you can help me with the most easiest and efficient way (Formula or VB code) to get an excel spreadsheet to Concatenate data from mutiple cells only if those individual contain certain values as shown in the example table below. Example...
    • SKooLZ
    • Thread
    • concatenate column values concatenate formula concatenate macro
    • Replies: 4
    • Forum: Excel Questions
  2. J

    Concatenate and set Bold to first string - how to use across more than one row

    Hello everyone, I have encountered the following scenario. I need to concatenate two cells into a third cell while adding a ": " to act as a divider between the two, in columns 1000 cells deep. I also need to make the divider and all text before it BOLD. I have been using the following code from...
  3. F

    Excel Macro - Concatenate columns(user selected) and replace them with new column

    I'm not an advanced VBA programmer. I'm working on an excel macro which will allow me to select a range(using input box) to clean the data(makes consistent with mySQL schema) on worksheet. I get this file from anther team and 1.) the order of columns is not fixed 2) levels of...
  4. A

    Help with writing a macro to concatenate data

    Hi Guys, First of all I have been a huge fan of this forum for years veyr good work thanks a bunch! My problem is I have data in the same format each month and need to concatenate each row with a comma between them. The data I need to concatenate is in column E and the the number of rows are...

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