Hi,

I would like to know if there's a quicker way of merging data in multiple cells into only 1 cell? I've tried a few formulas that don't really work as there's a lot of data that I need condensed down into only one cell and the formulas I've tried don't transfer everything over. At the moment I'm just cutting and pasting or highlighting all the cells pasting them into wordpad making the corrections and then pasting it all over onto the new database.

I'm updating databases for my new clients from the old database and currently it's really slow.

Thanks in advance.