I am currently exporting data to an excel worksheet.

One of the data consist an address field which when exported to excel, will be in a multi line order. eg.

vba building
22 new york street
new york 122655

but the problem is that beside name of building, address and postal code will appear a square symbol (i'm guessing its becos of the enter key which allows multiline data). tried to do the replace function to replace the square with a blank, but it didnt work, squares still visible.

anyone know how to make the square box dissapear?