Macro that will compress the 3 rows into one

Hi guys,

I have an excel with the export data that is not ok as the address is on 3 lines or more sometimes. I want what is in between the name of the company to be inserted into a cell. I want to have full name and the address into the same row.

Please find attached the image of the file.

Hope you can help.

Thanks,
Ionut

Try this

Please Login or Register  to view this content.

Hi Yasser,

Thank you ! is working! But when I will have 2 or more than 3 rows for the address what should I do?

Is there a way to make it dynamic?

Thank you,
Ionut

Did you mean by dynamic to determine the last row of data .. ??
If so I did it using the variable Lr ..