VBA to Concatenate Cells, Range and Strings

Thank you so much 😊😊😊😊😊😊😊😊

Hi, it was really a very insightful and useful video for me, I'm myself developing a Macro to concatenate a list of data in comma delimited format. Can you please provide an Idea on how to create a shortcut key rather than a command button to run the concatenate function on a group of selected cells?

i would like to have the concatenated range also start with the separator, how would I need to modify the VBA ?

Thank you . This helped me

How to merge multiple columns with concatnate function in vba. 500.000 row.

Thank you so much!

Thank you, Very Helpful

Thank you very much!!!. This is what I am looking for.

thanx for this video

I really appreciate your video tutorial. But i have a question, how can I concatenate the Column B and C and the result must show in Column A. And For example, in column B I have hundreds of data same with column C? Please help with this. Thank you so much in advance.

Very good and easy sir, thank you. Is it possible to use this in filtered condition?

Thank you for your time and explaining it so easily. I do dispatch for eBay and Amazon and after downloading files from these shops I need to put them into certain templates for different couriers. Now if I want to concatenate item codes for example 123456 in column C with postcode in column R with a separator “:”, how can I make a macro for them in Column Q.
All my files for different couriers are made through running running different macros. Kindly advise.

I need help with transferring the concatenated data to a cell in a different sheet.

This saved me so much time! Thanks a lot

Hey, nice video bro but it can be done using simple functions as well (Not a coding guy here)


Say for Example : by combining two Formula such as : CONCATENATE(TRANSPOSE(range of cells&"-"))


For the values mentioned in above video I used it as follows:

=CONCATENATE(TRANSPOSE(A2:A8&"-"))

Now when we add these value do not hit enter and rather select the Transpose function internally i.e., <TRANSPOSE(A2:A8&"-")> and click on F9 key which will give you the result with additional curly brackets which needs to be removed and click on enter and there you go the result is : "Jan-Feb-Mar-Apr-May-Jun-Jul-"

I just gave this suggestion as am not good at coding or using VBA codes

Hi ,


Can you tell me the concatenation of two cells where one should be bold and other hould be bold and italics ?

This is very close to what I need. I have data points grouped together, sperated by an empty row. But when I do to last row, it concatenate all data into one cell. I would need this for every data set that is sperated by a empty cell.

Good vídeo, help me alot. But i have a question, i need to do that but with a restriction. Example: i have a column with a status, and i just want to concatenate in a specific status.

Thanks a lot for a very good video. i have some query, If the data is arrange by columns not by row, how can we change for i=2 to lastrow?

Here is 2 columns in Excel 1 represents rendom variables (less than 4 and more than 4) and in 2nd column there is constant range of variables such as vehicle numbers and invoice numbers , how to write. Vba code or without coding , is it possible to manage data of concatenate ????

Thank you so much. I couldn't sleep last night because of not getting solution to this

Thank for the update... very nice

Hi, I follow your videos for daily Excel activity through VBA. May I have your contact number and email I'd. TIA.