VBA to Concatenate Cells, Range and Strings

This Tutorial explains VBA Code to Concatenate Cells, Add multiple strings etc. It takes lot of time to concatenate multiple cells, however VBA programming can concatenate multiple text values or range very quickly.

[macolloyd]

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

[sehaj]

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

[farhanmeer]

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:



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 :

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

[ClaytonHoward]

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.

[rahulbhargavarbatz]

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?

[tariqshahuk]

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.

[MasterChelsea]

Thank you!!
Can anybody tell me how to TRIM the text in this VBA

[adamslade]

This saved me so much time! Thanks a lot

[thinkhelpservice]

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

[samrajkumar]

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

[ritupallavi]

Hi,


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

[LyNguyenTiVi]

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

[matheuscosta]

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.

[soo_lit_life]

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

[ninamillagracia]

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.

[muhdfadhil]

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?

[priyesh]

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 ????