I need to concatenate four cells into a single cell string, ie,
First Name, Second Name, Arrival Date, Departure Date. The dates are in the form 03/04/2018 in a column of cells with date dd/mm/yyyy format.
Using CONCATENATE how can I keep the date cell contents to display in date format when they are written into the single cell?
Budge