hello

thank you for your reply.

Yes, my first thought was to change the address block format.

The data address block is sent to us in the current "block" format in an excel sheet that I have to import into Access (2016), when I try and change the format from the "wrap" format that it seems to be in, I then get problems trying to import the data in to access, access crashes and will not import it.

I tried removing the carriage returns using methods I have found including find and replace ctrl+J, but as mentioned I get errors when I try and import the data.

The address block could be typically between 3 and 6 lines so there is no standard format except that the last line will be the "Postcode" and the second to last line is the "Post Town", as such it just seemed easier to work with what I had, which was fine until I tried to do this merge which I must add the address in one line.

I can obviously remove the breaks manually after import but has I am looking at doing several hundred per day it would seem easier to remove the carriage returns.

I was just wondering if there was any other work around.

Thank you again for your reply