ExcelBanter - Concatenate using Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Concatenate using Macro (https://www.excelbanter.com/excel-discussion-misc-queries/269042-concatenate-using-macro.html)

Gaura215

Concatenate using Macro

I want to concatenate 5 coloums in a way that every coloums when get concatenated come in the next line in the same cell. Info should look like below:

Khalid Hannouneh
EGL Eagle Global Logistics
Al Madinah Al Monawarh St, #404
Al Samah Commercial Complex
Amman
11953
JORDAN
962-6-5548021

Please someone help

All times are GMT +1. The time now is 06:53 PM.