this did what you said however as a calculated field it will not allow me to delete the fields tai know longer need. I was hoping to tidy our database by merging a couple of fields and deleting those no longer required.
You could also switch to the multi-column list view, then select the column for the Calculated field, then press command-c to copy. Then create a new Text field, click on the first cell of the first row in that column, then paste. Now you’ve got the combined value from the two fields into a third field (via the Calculation field).