Over the past few years I have created a database of around 23,000 records in an Excel spreadsheet. For reasons which are now no longer applicable, the company surname was put in one column and the initials/first name of the company was put in a separate column - thus Joe W Bloggs & Co Ltd would have Joe W in column A and Bloggs & Co Ltd in column B. I now need to merge the colums into one so that I can import data from an online database vendor which uses only a single column for the full company name. Can anyone help? If I need a macro, can anyone provide one for me for this specific purpose, please? Incidentally, should I ever need to separate the single column into two, is that possible?