I am working on two spreadsheets. The first one is our main database, and I
want to insert data from the second spreadsheet. My problems is that the
first spreadsheet has both the first name and surname in one cell under
"contact name", whereas the second spreadsheet as the first names and
surnames split between separate columns.

Is there a way to combine the two columns to put the first names and
surnames on the second spread sheet in one column? There are around 590 rows
in the second spreadsheet (1,000s) in the first, so I don't really want to
enter the names manually!